Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) |