Hello,
I have some cells under conditional formatting rules to highlight it a certain color. In another worksheet, I want it to pull a particular value if that cell color is highlighted. How would I go about doing this?
~~~~~~~
=if(F5=ORANGE,"",D6)
~~~~~~~
USING EXCEL 2010