copy color from one sheet to another, not with CF

[squirrellydw]

Is there away I can copy color from one sheet to another without using conditional formatting because I don't think it will work. What I'm trying to do is have a list of names on one sheet and whenever that name is listed anywhere on another sheet have it show up as red. thanks

 

[kevin9999]

No, one rule does the entire range.

 

[squirrellydw]

No, one rule does the entire range.

thank you very much. This will work. Really appreciate it

 

[kevin9999]

Happy to help, and thanks for the feedback