Hello,
This may be basic question but I am unable to figure it out.
I am trying to apply conditional formating as in attached sheet. I have data in Column A & Column B, if Column B is zero then it should change color in Column A. It is working fine but if I have any empty cells in between in Column A, it is applying the Conditional Formating even to the blank cells (Which I dont want).
Please help me in getting this resolved.
Regards,
Humac
Last edited by humacdeep; 02-15-2012 at 01:32 PM.
Change your conditional formatting formula to -
=AND($B3=0,$B3<>"")
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks a LOT....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks