View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default How to apply conditional formatting on group of cells by using dat

Hi,
I have a sheet for tracking vacation plan. In this sheet I want to make a
conditional formatting. The sheet contains three columns, the first one is
employee name, and the second one is last working day, the third one is
return to work. I want to apply specific conditional formatting on the three
columns by special conditional as follows:
If the last working day date is over due itself, the all columns to be
filled with color automatically.
Your help is highly appreciated