View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keep It Simple Stupid Keep It Simple Stupid is offline
external usenet poster
 
Posts: 1
Default format certain values

I have 3 different codes in column D: PA, NB, and P5.
In column E I have different rates. I need to highlight the rows where PA
does not equal $10, NB does not equal $0, and P5 does not equal $3.
Is there a way to highlight the entire row or even one of the cells?