MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting, more than one column based on same criteria


Posted by Randy Evans on March 04, 2001 2:08 PM

Using conditional formatting I can get the number 8 to be bold because it is greater than the number 5, but how would I also get Atlanta to be bold? I want to highlight the winning score and winning team. Columns laid out as in this example.

A B C D
1. Chicago 5 Atlanta 8


Posted by steve on March 04, 2001 2:33 PM

A B C D

Use conditional format in the cell with the name , use the formula is and put
for atlanta located in c1 put the following in the conditional format formula
=D1>B1
for chicago located in A1 put the following in the conditional format formula
=D1<B1<p>let me know if you need eany more help

steve

Posted by Aladin Akyurek on March 04, 2001 3:00 PM

A B C D

While in A1, activate Conditional Formatting. Choose 'Formula is' for Condition 1 and type

=AND(ISTEXT(A1),B1>5) [ no $$ ] and apply Format

Again choose 'Formula is' for Condition 2 and type

=AND(ISNUMBER(A1),A1>5) [ no $$ ] and apply Format

Now, while still in A1, click on the 'Format Painter" icon and apply it to the rest of the cells in one go.

Posted by Randy on March 05, 2001 3:48 PM

Thanks guys,
I was trying to make the CF formula more complicated than it really needed to be.