Hello. Is there a way that I can find or highlight cells in a column that have a value of 0, AND are between two adjacent cells that are non-zero. For example, highlight B2=0, when A2 and C2 have non-zero values. This might take a macro I suppose.
Hello. Is there a way that I can find or highlight cells in a column that have a value of 0, AND are between two adjacent cells that are non-zero. For example, highlight B2=0, when A2 and C2 have non-zero values. This might take a macro I suppose.
You can achieve this with the help of conditional formatting. To do this, select the range starting from B2 (say B2:E100) and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
This formula assumes that in your selected range B2 is the first cell (Active Cell) in the range. If your range is different, use the reference of first cell of the selected range in the formula given above and also change the reference of the adjacent cells.Please Login or Register to view this content.
If you want to exclude blank cells from the rule i.e. you want to highlight the B2 only when it is not blank and meet your other criteria, use the below formula for conditional formatting.
Does this help?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi
=AND(B2=0,A2<>0,C2<>0)
Try This
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks