Thread
:
add fill color or font color to if function
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Nattasiray
external usenet poster
Posts: 3
add fill color or font color to if function
Please send file to me at
. I will figure out.
"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?
Reply With Quote
Nattasiray
View Public Profile
Find all posts by Nattasiray