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

Thanks in advance

Hi James,

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

Gav.

"james" wrote:

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

Thanks in advance

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

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

FormatConditional FormattingCell Value is: greater than or equal to 10

Format to Blue Pattern.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 01:37:03 -0800, james wrote:

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

Thanks in advance