R
rojoreds
I have searched the forum and find some things that help but not quite
enough. I have a table of numbers. In fact there are 300 rows of 5
colums of numbers. What I would like to do is to change the color of
the number if it matches one of 5 other numbers.
Example Reference #s 2 6 23 43 48
01 02 09 08 14
06 14 23 43 44
03 11 23 24 52
etc etc
etc etc
The example list is already populated. When the reference numbers are
entered I want any number in the example list that matches any number
in
the reference list to change to a specified color. Any way to do this.
Conditional formatting would work I think but I can only have three
condition and I need at least 5 maybe 6. Thanks
enough. I have a table of numbers. In fact there are 300 rows of 5
colums of numbers. What I would like to do is to change the color of
the number if it matches one of 5 other numbers.
Example Reference #s 2 6 23 43 48
01 02 09 08 14
06 14 23 43 44
03 11 23 24 52
etc etc
etc etc
The example list is already populated. When the reference numbers are
entered I want any number in the example list that matches any number
in
the reference list to change to a specified color. Any way to do this.
Conditional formatting would work I think but I can only have three
condition and I need at least 5 maybe 6. Thanks