conditionally changing colors in a cell

  • Thread starter Thread starter quintanajf
  • Start date Start date
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?
 
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
 
format>conditional formatting>
cell value is = to GO >format pattern to green
add
do stop, etc
 
Back
Top