Excel unable to skip blanks in conditional formatting

0
votes

I have some calculations on column C with values from 0 to 100, and I want to highlight any cell that contains a value of less than 95. I added conditional formatting where if cell value < 95, the cell is shown in red, using the formula =$C:$C. Of course this means that all the empty cells are getting marked as red but I want these to remain unformatted.

I have tried editing the formula to something like =AND($C<>"",$C:$C) but on clicking apply the formula is automatically switched to =($C:$C).

1
excelconditional-formatting

1 Answers

1
votes

Select the column you want to apply the conditional formatting on (in your case C). Set the formula as =And($C1<95, $C1>0)