View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default 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?