Conditional Formatting limitations...
 

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


---
Message posted from http://www.ExcelForum.com/

Conditional Formatting limitations...
 

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

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


---
Message posted from http://www.ExcelForum.com/