C
Conditional Format Issue
I have three tables, that are measuring three different values for the same
item. If all three values are above a certain value, say 2 for example, then
I want all three cells to be highlighted in yellow. So just to clarify: item
A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
item A in table 3 might have a value of 2.1. If that's the case, I want the
cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
this to apply to 3 tables each with 25 items. Any help is much appreciated.
item. If all three values are above a certain value, say 2 for example, then
I want all three cells to be highlighted in yellow. So just to clarify: item
A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
item A in table 3 might have a value of 2.1. If that's the case, I want the
cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
this to apply to 3 tables each with 25 items. Any help is much appreciated.