View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sri Sri is offline
external usenet poster
 
Posts: 2
Default Highlight cells based on conditions

On Apr 30, 11:27*am, Vic wrote:
I need to highlight cell B if it is greater than cell C of the same row,
providing that cell C is NOT blank. All cells formated as date.

Thank you.


You can use conditional formatting for this. Select Column B - Go to
Format - Conditional formatting - Cell is - Greater than - ... I
think you can proceed from here. Just change the format to highlight B.