Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

Clinton

unread,
Nov 24, 2009, 6:54:03 PM11/24/09
to
Hi,
I need to highlight various cells in 1 row based on a list of dates in a
separate column.

Peo Sjoblom

unread,
Nov 24, 2009, 7:27:57 PM11/24/09
to
Look in help for conditional formatting or post a more concrete example

--


Regards,


Peo Sjoblom


"Clinton" <Cli...@discussions.microsoft.com> wrote in message
news:9631D926-8C85-47F3...@microsoft.com...

David Biddulph

unread,
Nov 25, 2009, 3:03:20 AM11/25/09
to
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" <Cli...@discussions.microsoft.com> wrote in message
news:9631D926-8C85-47F3...@microsoft.com...

0 new messages