If statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was just wondering if it was possible to write an If statement so that if a
value is below a certain level, then you can make it a certain fill colour
i.e. =IF(<10, Red, White) but obviously not like this!

Many Thanks,
Matt
 
Try this:

Select the cells to be impacted.
Then...From the Excel main menu:
<format><conditional formatting>
Cell value is: Less than..(enter the value, e.g. 10)
Click the [formatting] button.....and set the format you want to use
Click the [OK] buttons

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Highlight your range
Format>Conditional Formatting>Cell Value Is>select less than>10
Click Format and pick any color you want
 
Back
Top