Need a cell to change colour based upon a word in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
If the word Promotion is in cell A1, then the cell C5 needs to change?
conditional format only allows me to do it if I were in A1 - doesn't it
 
Hi
- select C5
- goto the conditional format dialog
- choose 'formula' from the dropdown
- now enter
=$A$1="Promotion"
- choose your format
 
Fantastic, yet again you've helped me.

Frank Kabel said:
Hi
- select C5
- goto the conditional format dialog
- choose 'formula' from the dropdown
- now enter
=$A$1="Promotion"
- choose your format
Click to expand...
 
You must log in or register to reply here.

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

Changing coloue cell en text colour by clicking cell 3
Calculations based on cell colour 6
Format Cells - Fill colour Help 11
Remove colour change 4
How to make a cell equal another cells colour? 3
Insert blank row after change in cell value not working. 1
Using CF to change colour in cell based on date? 4
view cell fill colour on screen 1

Back
Top