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

In article <3l1e5kF10inc8U1@individual.net>,
"Optiglaze" <optiglaze@gmail.com> wrote:

> 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

[Optiglaze]

Fantastic, thanks.

Rick

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-0DCC2E.07410630072005@msnews.microsoft.com...
> One way:
>
> Select D19.
>
> CF1: Formula is =COUNTA(C19:C22)
> Format1: Font/Red
>
> In article <3l1e5kF10inc8U1@individual.net>,
> "Optiglaze" <optiglaze@gmail.com> wrote:
>
> > 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