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.
