Conditional format Highlight numbers less than 100

[matthewR]

I would like to do a conditional format and highlight numbers in column C less than 100. The problem is there are blanks in the column. I tried =(C1)<100 - but the less than 100 numbers highlight and so do the blanks.

[HansV]

Try using this formula to determine which cells to format:

=AND(C1<100,NOT(ISBLANK(C1)))

[StuartR]

=AND(C1<100,NOT(ISBLANK(C1)))

I sometimes have to do this when C1 contains a formula, that leaves the cell apparently blank. In this case I use
=AND(C1<100,LEN(C1)>0)

[HansV]

Good point!