1

Hopefully some one can help, but not sure if its possible. I'm using Excel 2010.

I want to change the background colour of a whole worksheet to green if the value in cell c20 is equal to or greater than the value in cell C21.

Any help would be appreciated.

Many Thanks

2
  • You don't list VBa as an option and it may have to be... There appears to be no way to do this directly. Or do you really not want VBa?
    – Dave
    Sep 11, 2013 at 12:40
  • Under what circumstance would you like to change the color of all the cells? When and how does the cell get updated?
    – user222864
    Sep 11, 2013 at 12:45

1 Answer 1

2
  1. Select all cells on the sheet
  2. Go to "Conditional Formatting" -> "New Rule..."
  3. Under "Select a Rule Type:", select "Use a formula to determine which cells to format"
  4. In the box below "Format values where this formula is true:", type in =$C$20>=$C$21
  5. Then click on the "Format" button to choose which styling you wish to apply. For background colour, go to the "Fill" tab.

Note: these steps apply to Excel 2007 but should be mostly similar in Excel 2010.

1
  • Works perfectly! Thanks for your help, really appreciate it! Sep 11, 2013 at 15:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .