Excel code needed 4 matching text color only 4rm cell 2 cell

Microsoft Excel 2010 - complete product...
March 3, 2012 at 16:18:11
Specs: Windows 7
I am working on a excel spread sheet for my job. It has the following conditional formatting. If text is nmcs text will be red and I need a code to make another cell match the color of the nmcs cell but keep the information from another cell that is linked. Please help!

See More: Excel code needed 4 matching text color only 4rm cell 2 cell

Report •


#1
March 3, 2012 at 17:24:54
Why not just use the same conditional formatting rule for the linked cell?

e.g. If you want B1 to match A1, just CF B1 with something like:

=A1=''your text string''

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question