add fill color or font color to if function
The =TRUE is unnecessary. As long as all cells E17, G16, H16 have numbers
(and not text that looks like numbers), then this should work:
=AND(E17<G16,E17<H16)
--
** John C **
"MEDaniel" wrote:
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?
|