Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If using conditional formatting testing for a non blank cell to this would
suffice =A1<"" -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Toppers" wrote in message ... Probably use an IF/AND condition Something like: Formula is: =IF(AND(A1<"",A1=condition)) HTH "Kman" wrote: I want to make a conditional format that will leave the cell unchanged if the cell involved is blank. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formating if cell not empty | Excel Discussion (Misc queries) | |||
sort a cell that was highlighted by conditional formating? | Excel Worksheet Functions | |||
conditional formating for blank. | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |