Online archive of questions on various topics answered by our experts. You can also ask a question (registration is required)

Related questions

How do I make a cell in Excel display a value based on the background color of another cell?

+122 votes
How do I make a cell in Excel display a value based on the background color of another cell?
by (4.5k points)

2 Answers

+45 votes
 
Best answer
why don't you use an IF() formula with the same criteria as the ones used for conditional format. It will return the x value when the conditions are met and the Y value when not.
by (4.2k points)
selected by
0 votes
Here are some custom functions for working with cell colors: . http://www.cpearson.com/excel/colors.htm. Note that there are several shades of green or red color and each have a different code
by (4.4k points)
...