View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.