add fill color or font color to if function
Added conditional formatting. Typed number into cell. no color change. ????
"Nattasiray" wrote:
You should using Conditional Formatting
Suppose cell that you check is I17
Select Cell I17
click format - Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog
"MEDaniel" wrote:
I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?
|