View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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?