conditionally changing colors in a cell

Q

quintanajf

i am trying to change the background color of a cell when a cell

example

STOP RED
SLOW YELLOW
GO GREEN

STOP =VLOOKUP(A5,LIGHT,2,FALSE)

this is my basic stop light when stop is typed into cell a5 i want b5
to change to red, same for slow and go.

do i have to use vba? or can this be done as a function?
 
C

Carim

Since you only have 3 condiotns, conditional formatting will work fine
....
Format Conditional Formatting Cell Value Is Equal To "Stop" pick red
background ...
Then Add your two next conditions and colors ...

HTH
Carim
 
D

Don Guillett

format>conditional formatting>
cell value is = to GO >format pattern to green
add
do stop, etc
 
Top