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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Help when a Cell is Blank
Hi Nickle,
try this, open a new workbook, in cell a1 enter conditional formating, where the formula is, type the formula, ok, then open the conditional formating again and check that the formula is exactly the same I has sent to you, if you see " at the beginning or end of the formula delete it "Nickle" wrote: A1 still comes back with Red lettering when using this formula even though B1 has no value in the cell. Any idea? |
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) |