Remove blank cell from conditional formatting
Closed
doca023
Posts
1
Registration date
Friday May 29, 2009
Status
Member
Last seen
May 30, 2009
-
May 30, 2009 at 02:21 PM
chandru - Sep 11, 2009 at 07:15 AM
chandru - Sep 11, 2009 at 07:15 AM
Related:
- Remove conditional formatting from blank cells
- How to stop conditional formatting on blank cells - Best answers
- Stop conditional formatting if blank - Best answers
- Conditional formatting if cell contains text - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Windows defender can't remove threat ✓ - Viruses & Security Forum
- How to remove story from close friends - Instagram Forum
- Different dates of end to end encryption message on blank chat ✓ - WhatsApp Forum
4 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 1, 2009 at 01:57 AM
Jun 1, 2009 at 01:57 AM
Lets you are implying conditional formatting on Cell A2 and comparing it with A1. the condition you are applying is that if A2 < A1 then highlight the cell.
Now go in Conditional Formatting and add Condition 1 by using Forumula = ISBLANK(A2) now don't hight light the background
Now apply Condition 2 as Formula = =A2<A1 now change the pattern ........
Result : If your cell A2 is blank your 1st condition will be true and nothing will be happened with Cell. if you put something in Cell A2 and that is less then A1 then background/pattern will change the cell format ....
if any confusion, get back to me .....
Now go in Conditional Formatting and add Condition 1 by using Forumula = ISBLANK(A2) now don't hight light the background
Now apply Condition 2 as Formula = =A2<A1 now change the pattern ........
Result : If your cell A2 is blank your 1st condition will be true and nothing will be happened with Cell. if you put something in Cell A2 and that is less then A1 then background/pattern will change the cell format ....
if any confusion, get back to me .....