Conditional formatting

[james]

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

Thanks in advance

 

[Gav123]

Hi James,

Can you please provide an example of what you are trying to achieve.

Gav.

 

[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