Conditional Highlight
Here is another complication to this:
Add 17 in cell A if cell G is highlighted,
Add 10 in cell A for each cell from H thru P that is highlighted
Add 1 in cell A for each cell from Q thru AA that is highlighted
Add 11 in cell A if cell AB is highlighted
Add 1 in cell A for each cell from AC thru AE that is highlighted
"Vic" wrote:
I need to highlight cell A in Yellow if any of the cells G thru AE in that
row are highlighted in any color but white (no color). How do I do this?
|