Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Hi,
I want to turn one cell green (f45) based on another cell (a45) having a zero in it. Seems simple enough, and I thought it would be as straightforward as: =a1=0 I should also mention that this is condition 3. The first 2 conditions a =A45=MAX(A45:B45) format is red =B45=MAX(A45:B45) format is blue The reason I need a third condition is that sometimes the source cells will have zeroes in, so I need this to be reflected as a colour other than those used for conditions 1 and 2, as excel is currently returning a format of red for source cells with zero in. Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
You need to make the 0 condition your first condition. If you have it as
your last condition, and A45 was zero and B45 was 12, then the condition of A45=MAX(A45:B45) will be met first. Condition 1: =A45=0 Condition 1: =B45=MAX(A45:B45) Condition 1: =A45=MAX(A45:B45) HTH, Paul "Kierano" wrote in message ... Hi, I want to turn one cell green (f45) based on another cell (a45) having a zero in it. Seems simple enough, and I thought it would be as straightforward as: =a1=0 I should also mention that this is condition 3. The first 2 conditions a =A45=MAX(A45:B45) format is red =B45=MAX(A45:B45) format is blue The reason I need a third condition is that sometimes the source cells will have zeroes in, so I need this to be reflected as a colour other than those used for conditions 1 and 2, as excel is currently returning a format of red for source cells with zero in. Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Try putting your 3rd condition first. Conditional formatting finds the
first "True" value in the contitions and then stops, so since 0 might be the max for your range a true value will result in condition1 and will never get to condition 3. HTH Sandy Kierano wrote: Hi, I want to turn one cell green (f45) based on another cell (a45) having a zero in it. Seems simple enough, and I thought it would be as straightforward as: =a1=0 I should also mention that this is condition 3. The first 2 conditions a =A45=MAX(A45:B45) format is red =B45=MAX(A45:B45) format is blue The reason I need a third condition is that sometimes the source cells will have zeroes in, so I need this to be reflected as a colour other than those used for conditions 1 and 2, as excel is currently returning a format of red for source cells with zero in. Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |