Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
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 '13 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? –  vba4all Sep 11 '13 at 12:45

1 Answer 1

up vote 2 down vote accepted
  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.

share|improve this answer
    
Works perfectly! Thanks for your help, really appreciate it! –  Jez Vander Brown Sep 11 '13 at 15:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.