Conditional Formatting based on Cell Number and Color

[kumasu]

I have a scorecard that has a scoring grid with values 1-5. Each number has a set color. 1 = Red , 2 = Orange , 3 - Yellow, 4 = Light Green, 5 = Green. When a user enters one of those values from the, the cell's color should automatically match that of the grid. Meaning, if I enter a score of 3 for Level of Happiness, then the field should be colored "Yellow" based on the grid.

 

[kevin9999]

Do you mean like something this?

Book1
	A	B	C	D
1	Score 1-5
2	1	5	1	2
3	2	3	5	5
4	5	4	5	5
5		5		5
6		1	5
7		2	5	4
8	5	3	5	3
9	4	5	4	2
10	3	1		1
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D10	Cell Value	=1	text	YES
A2:D10	Cell Value	=2	text	YES
A2:D10	Cell Value	=3	text	YES
A2:D10	Cell Value	=4	text	YES
A2:D10	Cell Value	=5	text	YES