| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Help when a Cell is Blank
I am trying to format a cell that has three scenario's.
1. If A1=B1, then the text will be green 2. If A1 does not equal B1, then the text will be red 3. If B1 is empty/blank, then A1 has no formatting. The value of B1 is dependant on a value that is selected from the Master Sheet. So B1 has a formula that is attached to it. I am having difficulties getting A1 to have no formatting if nothing has been filled/selected for B1. Any ideas would help. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help when a Cell is Blank
Hi,
in conditional formating enter =AND(B1<"",B1<A1) then set up the colour to be red "Nickle" wrote: I am trying to format a cell that has three scenario's. 1. If A1=B1, then the text will be green 2. If A1 does not equal B1, then the text will be red 3. If B1 is empty/blank, then A1 has no formatting. The value of B1 is dependant on a value that is selected from the Master Sheet. So B1 has a formula that is attached to it. I am having difficulties getting A1 to have no formatting if nothing has been filled/selected for B1. Any ideas would help. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting if cell is Blank | Excel Worksheet Functions | |||
| conditional formatting date and blank cell | Excel Discussion (Misc queries) | |||
| Conditional formatting - check for blank cell | Excel Discussion (Misc queries) | |||
| put zero in blank cell using conditional formatting | Excel Worksheet Functions | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
