Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
Can I conditionally format one cell that is affected by another cells
numbers? For example can i conditionally format a1 to be green if cell b2 is <= to 100%, yellow if =95 but <100, and red if <95. And if so what is the key stroke for <= in a function statement? |
#2
|
|||
|
|||
one way in cell A1
Condition one formula is =if(b2<95,1,0) and format red Condition 2 formula is =if(b2=95,if(B2<100,1,0),0) and format to yellow If cell b2 is formated to % change to decimal .95 and 1.0 HTH "Duser" wrote: Can I conditionally format one cell that is affected by another cells numbers? For example can i conditionally format a1 to be green if cell b2 is <= to 100%, yellow if =95 but <100, and red if <95. And if so what is the key stroke for <= in a function statement? |
#3
|
|||
|
|||
Yes you can -
First, go into Format-Conditional Formatting. Under Condition 1, choose "Formula Is" and enter this function: =IF(B2=1,TRUE,FALSE) and format this to green. Choose "Add" to add another condition, choose "Formula Is" again, and enter this function into condition 2: =IF(AND(B2=.95,B2<1),TRUE,FALSE) and format this to yellow. Similarly add another condition, "Formula Is" again, and enter this formula into condition 3: =IF(B2<.95,TRUE,FALSE) and format this to red. -- Regards, Dave "Duser" wrote: Can I conditionally format one cell that is affected by another cells numbers? For example can i conditionally format a1 to be green if cell b2 is <= to 100%, yellow if =95 but <100, and red if <95. And if so what is the key stroke for <= in a function statement? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |