Conditional Formating multiple cells in 1 row based on a list of d
 

Hi,
I need to highlight various cells in 1 row based on a list of dates in a
separate column.

Conditional Formating multiple cells in 1 row based on a list of d
 

Look in help for conditional formatting or post a more concrete example

--


Regards,


Peo Sjoblom


"Clinton" wrote in message
...
Hi,
I need to highlight various cells in 1 row based on a list of dates in a
separate column.

Conditional Formating multiple cells in 1 row based on a list of d
 

In CF you'll need the "Formula Is", rather than "Cell Value Is" option.
If the formula evaluates to TRUE, rather than FALSE, then the CF will be
applied.
Don't forget to start your formula with an = sign, and be careful about
whether you want absolute or relative addressing.
--
David Biddulph

"Clinton" wrote in message
...
Hi,
I need to highlight various cells in 1 row based on a list of dates in a
separate column.