If statement

[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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Ah yes that is far more simple than what i was tihnking
Many Thanks guys!