I know there are many posts concerning this, but after scouring, I couldn't find one that fit my situation. I have a total of six worksheets, I am only concerned with two worksheets.
Worksheet (functions!)
This one has a list of numbers formatted as general. (Column G)
Is actually a formula/macro that outputs a number... (didn't know if this mattered?)
Worksheet (ACD!)
This one has a list of numbers formatted as text. (Column A)
Actual typed numbers.
I want to conditionally format the cells in (functions!$G) to turn green if it finds a match in (ACD!$A), and turn red if it doesn't find a match.
Thanks in advance for the help.
Bookmarks