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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Change Color of cell 3
Conditional formatting in Excel 2003 2
Moving cell contents to new cell loses background color in old cel 4
Conditional Formatting 3
Apply color of one cell to other 2
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
Conditional Formatting question with colors 4

Back
Top