Conditional Formatting Formula
I'm trying to conditionally format a rows of cells in comparison to a set row
of cells. That is, if A31.25*O3 or if O31.25*A3 format the value of A3 red
and bold. Then, if B31.25*O3 or if O31.25*B3 do the same, and on and on.
It's comparing monthly figures to year averages. I've tried several methods
and haven't had any luck! Any body know the secret? Thanks!
--
David Harmon Evans
|