how to change color of cell based on contents of cell

  • Thread starter Thread starter robert wake
  • Start date Start date
R

robert wake

how do i change the color of a cell based on the contents of the cell. ex.
when the cell says stop the color of the cell turns red, when contents go
turns to green
 
Hi Robert,
use conditional formation, where the formula is and there you enter ="Stop"
and choose the red color, then enter another formula which will be
="Go" and choose the color green
 
OPPs I didn't include the cell
Suppose the cell that contains Stop and Go is A1 so the formulas will be

A1="Stop" red color
A1="Go" Green color
 
Back
Top