Conditional Formatting

I have three tables, that are measuring three different values for the same
item. If all three values are above a certain value, say 2 for example, then
I want all three cells to be highlighted in yellow. So just to clarify: item
A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
item A in table 3 might have a value of 2.1. If that's the case, I want the
cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
this to apply to 3 tables each with 25 items. Any help is much appreciated.

Do you have three tables in MS Access, MS Word or ??????

Since it does not appear to be a Windows Vista problem, it would likely
be a good idea to ask you question in a newsgroup supporting the program you
are using.

--
Joseph Meehan

Dia 's Muire duit



"Conditional Format Issue" <Conditional Format
> wrote in message
news:876DE739-CF24-4BC6-A9FC-...
> I have three tables, that are measuring three different values for the
> same
> item. If all three values are above a certain value, say 2 for example,
> then
> I want all three cells to be highlighted in yellow. So just to clarify:
> item
> A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
> item A in table 3 might have a value of 2.1. If that's the case, I want
> the
> cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
> this to apply to 3 tables each with 25 items. Any help is much
> appreciated.

I am assuming this is about excel? You are posting in the wrong group and
should post in an office or excel one instead. This one is only about Vista.

Lori

--
Shop for clothes, boots, gothic, jewelry, collectible, Egyptian and more!
LAB Enterprises -
Read our blog with links to all our stores at www.Labeshops.com

"Conditional Format Issue" <Conditional Format
> wrote in message
news:876DE739-CF24-4BC6-A9FC-...
> I have three tables, that are measuring three different values for the
> same
> item. If all three values are above a certain value, say 2 for example,
> then
> I want all three cells to be highlighted in yellow. So just to clarify:
> item
> A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
> item A in table 3 might have a value of 2.1. If that's the case, I want
> the
> cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
> this to apply to 3 tables each with 25 items. Any help is much
> appreciated.

Assuming you are talking about an Excel spreadsheet.
Ask your question in an Excel newsgroup.--
-------
[When responding to posts, please include the post(s) you are replying to so
that others may learn and benefit from the issue]

[How to ask a question]
http://support.microsoft.com/kb/555375

"Conditional Format Issue" <Conditional Format
> wrote in message
news:876DE739-CF24-4BC6-A9FC-...
>I have three tables, that are measuring three different values for the same
> item. If all three values are above a certain value, say 2 for example,
> then
> I want all three cells to be highlighted in yellow. So just to clarify:
> item
> A in table 1 might have a value of 3, item A in table 2 might be 2.4, and
> item A in table 3 might have a value of 2.1. If that's the case, I want
> the
> cells that contain the values 3, 2.4, and 2.1 all to highlight. And I need
> this to apply to 3 tables each with 25 items. Any help is much
> appreciated.