Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1,
and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
With that cell active, use Home/Conditional Formatting, use new Rule, use
Use a formula to determine which cells to format and enter this formula: =AND(A1<B1,B1<"") then click format/fill/red then do another New Rule and use =AND(A1=B1,B1<"") then click format/fill/green. HTH Bob Umlas Excel MVP "Nickle" wrote in message ... I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
These two work fine, however my A1 cell turns Red when B1 is blank which I
was hoping to have no formatting for. Is there another equation that is needed. Thank you for the help. "Bob Umlas" wrote: With that cell active, use Home/Conditional Formatting, use new Rule, use Use a formula to determine which cells to format and enter this formula: =AND(A1<B1,B1<"") then click format/fill/red then do another New Rule and use =AND(A1=B1,B1<"") then click format/fill/green. HTH Bob Umlas Excel MVP "Nickle" wrote in message ... I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
It shouldn't go red if B1 is blank. Perhaps it is not blank. Perhaps
contains one or more spaces? What does =LEN(B1) show? -- David Biddulph "Nickle" wrote in message ... These two work fine, however my A1 cell turns Red when B1 is blank which I was hoping to have no formatting for. Is there another equation that is needed. Thank you for the help. "Bob Umlas" wrote: With that cell active, use Home/Conditional Formatting, use new Rule, use Use a formula to determine which cells to format and enter this formula: =AND(A1<B1,B1<"") then click format/fill/red then do another New Rule and use =AND(A1=B1,B1<"") then click format/fill/green. HTH Bob Umlas Excel MVP "Nickle" wrote in message ... I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
=LEN(B1) Shows 1
I do have a cell reference to another spreadsheet. So the outcome on B1 is dependent on what is selected from a cell on the Master sheet. "David Biddulph" wrote: It shouldn't go red if B1 is blank. Perhaps it is not blank. Perhaps contains one or more spaces? What does =LEN(B1) show? -- David Biddulph "Nickle" wrote in message ... These two work fine, however my A1 cell turns Red when B1 is blank which I was hoping to have no formatting for. Is there another equation that is needed. Thank you for the help. "Bob Umlas" wrote: With that cell active, use Home/Conditional Formatting, use new Rule, use Use a formula to determine which cells to format and enter this formula: =AND(A1<B1,B1<"") then click format/fill/red then do another New Rule and use =AND(A1=B1,B1<"") then click format/fill/green. HTH Bob Umlas Excel MVP "Nickle" wrote in message ... I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. . . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 3 Criteria Options
So if LEN(B1) is 1,it is not blank, so it will satisfy the B1<"" test, and
the red result is what you'd expect. What is your formula in B1? Are you sure that you haven't asked it to produce a space =" " rather than an empty string ="" ? =CODE(B1) will be 32 if you've got a space in there. -- David Biddulph "Nickle" wrote in message ... =LEN(B1) Shows 1 I do have a cell reference to another spreadsheet. So the outcome on B1 is dependent on what is selected from a cell on the Master sheet. "David Biddulph" wrote: It shouldn't go red if B1 is blank. Perhaps it is not blank. Perhaps contains one or more spaces? What does =LEN(B1) show? -- David Biddulph "Nickle" wrote in message ... These two work fine, however my A1 cell turns Red when B1 is blank which I was hoping to have no formatting for. Is there another equation that is needed. Thank you for the help. "Bob Umlas" wrote: With that cell active, use Home/Conditional Formatting, use new Rule, use Use a formula to determine which cells to format and enter this formula: =AND(A1<B1,B1<"") then click format/fill/red then do another New Rule and use =AND(A1=B1,B1<"") then click format/fill/green. HTH Bob Umlas Excel MVP "Nickle" wrote in message ... I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting 2 criteria in one row | Excel Discussion (Misc queries) | |||
Conditional Formatting of 4 criteria | Excel Discussion (Misc queries) | |||
Conditional Formatting with more than 3 Criteria | Excel Discussion (Misc queries) | |||
I need more that 3 Conditional Formatting Options | Excel Discussion (Misc queries) | |||
Conditional Formatting options | Excel Discussion (Misc queries) |