MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting


Posted by Excel Guru on December 11, 2001 11:30 AM

I have a list of data, and beside that list I have another list where data can be entered (eg "1"'s) I would like a condition where anytime a 1 is entered in any cell between a range (eg F4 - K24) I would like the entire row to turn red. I have tried using the conditional formating tool and have found making the rows absolute by using the '$' only works for the first column. Where as any '1' that is inserted in any cell in the first column the entire row turns red, but the columns following, (eg G,H,I,J, and K), if any '1' is inserted in any cell in those columns nothing happens to the row. Any help would be appreciated.

Excel Guru


Posted by Aladin Akyurek on December 11, 2001 11:47 AM

Select F4:K24.
Activate Format|Conditional Formatting.
Choose "Formula Is".
Enter as formula:

=COUNTIF($F4:$K4,1)>0

Activate Format.
Choose red on the Patterns tab.
Click OK.
Click OK.

Aladin

=========

Posted by Excel Guru on December 11, 2001 12:14 PM

Thank You for the solution (NT).