Thread: Excel
View Single Post
  #1   Report Post  
dipsy
 
Posts: n/a
Default Excel

Hi! I have a column full of dates. I want to do the
following based on dates:

1. If date is Feb-05 - then I want to color only Qtr1
cell.
2. If date is Dec-05 - then I want to color Qtr1, Qtr2,
Qtr3 & Qtr4.

Is there a way to do it?

Thanks.