Conditional formatting

J

james

Hi
I need cells to indicate a colour when they meet a formulas condition
otherwise they should be blank.

Thanks in advance
 
G

Gord Dibben

I would say you need a two-step operation here.

Formula in cell =IF(A1<10,"",A1) returns blank if value less than 10

Format>Conditional Formatting>Cell Value is: greater than or equal to 10

Format to Blue Pattern.


Gord Dibben MS Excel MVP
 
Top