if blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary - 26 Sep 2007 02:56 GMT

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

Reply to this Message

Gord Dibben - 26 Sep 2007 03:07 GMT

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

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 4 lines]
>Regards,
>Gary

Reply to this Message

Gord Dibben - 26 Sep 2007 03:22 GMT

Ooops!

Bad misread there.

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

Gord

>Format>CF>Formula is =NOT(ISBLANK($D$6))
>
[quoted text clipped - 8 lines]
>>Regards,
>>Gary

Reply to this Message

RagDyer - 26 Sep 2007 03:14 GMT

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

And set your format to a red pattern.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>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
[quoted text clipped - 4 lines]
> Regards,
> Gary

Reply to this Message

Gary - 26 Sep 2007 03:39 GMT

Thanks all, this works perfect...

> Select D6, then:
> <Formula Is>
[quoted text clipped - 9 lines]
>> Regards,
>> Gary

Reply to this Message

Wondering - 26 Sep 2007 03:19 GMT

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.

>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
[quoted text clipped - 4 lines]
> Regards,
> Gary

Reply to this Message

Rate this thread: