Conditional Formatting

[Optiglaze]

Hi,
I have used conditional formatting with effect but I am stumped on the
following,

If cells C19 thru C22 contain anything then I want the contents of cell D19
to be in a red font.

Thanks in advance for any help,
Rick

 

[JE McGimpsey]

One way:

Select D19.

CF1: Formula is =COUNTA(C19:C22)
Format1: Font/Red

 

[Optiglaze]

Fantastic, thanks.

Rick

One way:

Select D19.

CF1: Formula is =COUNTA(C19:C22)
Format1: Font/Red