Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I write a conditional "IF" statement to color a group of ce
What is the syntax to write a conditional statement to color a group of cells
red if larger than 50, yellow if between 50 & 20, and green if less than 20? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I write a conditional "IF" statement to color a groupof ce
What about exactly 50 or exactly 20?
mulehead wrote: What is the syntax to write a conditional statement to color a group of cells red if larger than 50, yellow if between 50 & 20, and green if less than 20? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I write a conditional "IF" statement to color a group of ce
Hi,
use conditional formatting. Select your group of cells then:- Format|Conditional format select cell value is|less than = to 20 and select a colour Click add for your second and third conditions. Mike "mulehead" wrote: What is the syntax to write a conditional statement to color a group of cells red if larger than 50, yellow if between 50 & 20, and green if less than 20? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
Can I include a "validation drop down" in a conditional statement? | Excel Worksheet Functions | |||
how do I write an "if then" statement in Excel. eg. If L47 = 0 the | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |