If statement
 

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

If statement
 

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


"Matt Dawson" wrote:

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

If statement
 

Highlight your range
FormatConditional FormattingCell Value Isselect less than10
Click Format and pick any color you want


"Matt Dawson" wrote:

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

If statement
 

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

"Teethless mama" wrote:

Highlight your range
FormatConditional FormattingCell Value Isselect less than10
Click Format and pick any color you want


"Matt Dawson" wrote:

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