IF formula to conditionally format a cell
Select C29
From menu FormatConditional FormattingCondition1
Formula Is
=AND(N410,N41<=1594)
Select a color to highlight
If this post helps click Yes
---------------
Jacob Skaria
"Very Basic User" wrote:
Sorry for the blank post, I hit enter to move to this box...
Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John
|