View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nattasiray Nattasiray is offline
external usenet poster
 
Posts: 3
Default add fill color or font color to if function

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?