Hi all,
I have been trying to highlight a cell with the same color as another cell (only the colors red, orange, and green should be considered). Whenever the color of cell A1 changes, the color of B1 should change accordingly. I have tried using conditional formatting and the CELL formula, but neither worked. I have been searching for a solution to this issue for a few days.
If someone could provide a solution for this problem, it would be highly helpful for me.
Regards,
Binu
What triggers a colour change in A1?
Fast answers need clear examples.
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks