Autocolor cells according to a DateRange

  • Thread starter Thread starter vicber
  • Start date Start date
V

vicber

Hello everyone,
I would like to enter a name, followed by a date range,
and that excel automatically colorize a row, depending of
the length of the range? Is it possible ?

Thanks
vicber
 
Hi
if you enter the date range in two separate fields (lets say in B1 and
C1; A1 stores the name) you may use conditional format:
- select the row (in this case row 1)
- goto 'Format - Conditional format'
- enter the formula
=$C1-$B1>some_value
-choose your format
 
Thanks Frank;
I think I need to re-formulate, actually, as this is not
exactly what I meant:
I'd like to have a sheet which will look like a calendar:
- Column A : Name
- Columns B to M: Months
If I enter a beginning date and an end date somewhere, I
would like the "calendar" be filled in with a color (that
could or not be "name specific") according to the date
range(i.e only 6 columns in a row for a six month duration)
Could you still help on that ?

Thanks
vicber
 
Back
Top