Remove blank cell from conditional formatting [Closed]

Posts
1
Registration date
Friday May 29, 2009
Status
Member
Last seen
May 30, 2009
- - Latest reply:  chandru - Sep 11, 2009 at 07:15 AM
Hello,
Please let me know how can I remove conditional formatting from blank cells? I set a formula (ex: smaller than other row) to determine which cell will be formated, of course blank cell will be formated also, and I want to avoid that. Thanks!
See more 

4 replies

Best answer
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
209
9
Thank you
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 .....

Say "Thank you" 9

A few words of thanks would be greatly appreciated. Add comment

CCM 5682 users have said thank you to us this month

7
Thank you
If you are using excel and using the conditional formatting the FIRST conditional formatting needs to be the cell value is equal to 0 and then set the conditioning to whatever you want it to be- I often leave this blank and then use other highlighting and such for conditional formatting as the second and third conditional formats.
2
Thank you
tell me what is the excel formula for copying text of present cell to next cell if it is empty
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
209
1
Thank you
.