Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Conditional Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Conditional Format Issue - 24 Mar 2008 23:26 GMT
I have three 10x10 tables and each have different values for the same item.
So all in all, there are 100 items with three values each. So for example,
the item in in the first column, first row of table one is the same as the
item in the first column, first row of table 2 and table 3. If the value of
item 1 is 3 in table 1, 2.5 in table 2, and 3.5 in table 3, how can I create
a rule that will highlight all of them if each value is greater than 2? So to
clarify, if the value in table 1 is 1.5, I don't want any of the values in
tables 1, 2, or 3, to highlight for item 1. In other words, I want each item
with all three values greater than 2 to be highlighted.
Bob Phillips - 24 Mar 2008 23:58 GMT
Assuming the tables are A1:J10, M1:V10, and AA1:AJ10, then select all 300
cells, A1:J10 last, and use a formula in CF of

=AND(A1>2,M1>2,AA1>2)

and format.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have three 10x10 tables and each have different values for the same item.
> So all in all, there are 100 items with three values each. So for example,
[quoted text clipped - 9 lines]
> item
> with all three values greater than 2 to be highlighted.
Conditional Format Issue - 25 Mar 2008 12:36 GMT
When I select all three tables, it only applies the formatting to the last
one - is there any way to work around this? I can select each table
individually, but I need to repeat this process multiple times and that would
be a nuisance. Another workaround would be to copy-paste conditional
formatting - is that possible?

> Assuming the tables are A1:J10, M1:V10, and AA1:AJ10, then select all 300
> cells, A1:J10 last, and use a formula in CF of
[quoted text clipped - 16 lines]
> > item
> > with all three values greater than 2 to be highlighted.
Bob Phillips - 25 Mar 2008 20:47 GMT
If you select one range, then Ctrl-Select another, then Ctrl-Select the
third, the third being A1:J10, that should work.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> When I select all three tables, it only applies the formatting to the last
> one - is there any way to work around this? I can select each table
[quoted text clipped - 29 lines]
>> > item
>> > with all three values greater than 2 to be highlighted.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.