Conditional Formatting limitations...

  • Thread starter Thread starter mjack003
  • Start date Start date
M

mjack003

Hi,

I have a problem with the limitations of conditional formatting. I
need to compare a list of numbers to another without summing the whole
list. I need to compare A16:A500 on all selected sheets with a master
list of numbers on another sheet in the same workbook from A6:A4500.
Any matches that are found on the master list need to be highilighted
in yellow. Is there any way to create a macro which can do this
quickly as I'm running on a slow computer? Any help would be great.

Regards,
Mjack
 
Hi Mjack
try the following (I assume you want the highlighting take place in the
other sheet):
- Define a name for your master range (goto 'Insert - Name - Define
Name'; lets say 'cond_range')
- In the other sheet select the range A6:A4500 and goto conditional
format
- enter the formula: =COUNTIF(cond_range,A6)>0
- choose your format

Frank
 
Back
Top