formula ?

[corphealth]

I have conditional formatting now working in a spreadsheet
where I have the months going across columns c5:i5 and
grand totals in column j5. I have the conditional
formatting working as follows to highlight drops in
revenues

=(d5<c5) and it works great, but also highlights cells
that are blank, what can I add to make only cells with #'s
highlighted.

Thanks in advance.

 

[Biff]

Hi!

Try this:

=AND(D5<>"",C5<>"",D5<C5)

Biff

 

[Ragdyer]

Try this:

=AND(D5<C5,D5<>"")

 

[corphealth]

Thank you for your assistance, I will try this in a few
minutes.