cHANGIN A CELL COLOUR BASED ON A CELL VALUE

  • Thread starter mohd21uk via OfficeKB.com
  • Start date
M

mohd21uk via OfficeKB.com

I would like to change a cell's background colour if a certain value is
entered in another cell. For e.g., if Yes is entered in cell a5 i would like
to have cell c9 in green. I would be grateful if you could provide me a
formula that could do this for me.
 

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

Excel does not accept text format! 0
Using colour conditional formatting to show whether due date has past 0
The sum of the same function that is used for a range of cells 2
Using checkbox to change cell color 2
Count Interior Colour 7
alternating cell colour 2
Function for summing or counting cells based on a specified fill color 3
Help - hiding multiple sets of rows based on two different cells 2

Top