Forum Discussion
Conditional Formatting based on a range of values
Hi everyone, I'm trying to highlight rows in a table based on values of cells in another table in another worksheet (sheet1). Both tables contain zip codes, however, the table in sheet1 divides the ...
- Yes, I'm pretty sure that the way you did it could be changed to highlight the whole row. Can please share with me how to apply it to my tables. 🙂
I changed the rule for conditional formatting from
=MATCH(A4,sheet2!$A$2:$A$8,0)
to
=MATCH($A4,sheet2!$A$2:$A$8,0)
The "applies to" range is =$A$4:$B$35
If you want to highlight e.g. columns A to H then change the "applies to" range to
=$A$4:$H$35
- THANK YOU VERY MUCH! It worked. Can you please explain the "0" in the match formula, so that I can use it in the future. ❤️
