MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional formatting ??

Posted by Bill on September 04, 2001 12:53 PM

I have a set of numbers in A1:A5 I want to make the numbers in D1:H25 red if any of the numbers match A1:A5 I can't get conditional formatting to work over a range. Thanks for your help.

Posted by Aladin Akyurek on September 04, 2001 1:09 PM

Select the range D1:H25.
Activate Format|Conditional Formmatting.
Select Formula Is for Condition 1.
Enter the following formula (att.: no dollar signs)


Choose the desired formatting.


Posted by Mark W. on September 04, 2001 1:17 PM

Or, use...

=OR(D1=$A$1:$A$5) as your condition.