Thread: Conditional Format to highlight differances between to sets of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Conditional Format to highlight differances between to sets ofdata
I do something similar.
I past this function in E2.
=IF(C2=D2," = ","Not =")

Then go to Format menu, Conditional Formatting...
and assigned green to "=", and red to "Not =".
Reply With QuoteReply With Quote