if blank

[Gary]

I want cell D6 to turn red if any text is written in cells F6-F20. The
typical condition in cells F6-F20 is blank. The cells remain blank unless
someone writes a note in the cells. I want cell D6 to alert me in red when
a note has been written. How would I write the Conditional Formating
formula?

Regards,
Gary

 

[Gord Dibben]

Format>CF>Formula is =NOT(ISBLANK($D$6))


Gord Dibben MS Excel MVP

 

[RagDyer]

Select D6, then:
<Formula Is>
=COUNTIF(F6:F20,"<>")>0

And set your format to a red pattern.

 

[Wondering]

One way is to use a formula in your conditional format for D6:

=IF(COUNTA(F6:F20)<>0,TRUE,FALSE)

and format the cell D6 with whatever fill color you want. COUNTA returns the
number of non-blank cells.

 

[Gord Dibben]

Ooops!

Bad misread there.

Select D6 and CF>Formula is =COUNTA($F$6:$F$20)>0


Gord

 

[Gary]

Thanks all, this works perfect...

Select D6, then:
<Formula Is>
=COUNTIF(F6:F20,"<>")>0

And set your format to a red pattern.