View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oldyork90 oldyork90 is offline
external usenet poster
 
Posts: 20
Default conditionally format based on intersheet cell comparisons

I have two sheets, A and B. Both sheets once had the same data. On
sheet A, some cells in col CC have been updated. I want to change the
background of Sht A, col CC cells if the value doesn't match
corresponding cell value in ShtB.

I can do this cell by cell... but can't figure out to select all the
cells at once.

Thank you.