Conditional cell colours in Excel - help please

  Taurus 29 Nov 12
Locked
Answered

Hi everyone, is there a way that Excel can be made to change the cell colours depending upon the cell contents? I have a group of cells that display the result of a sum. The cells are green (the default entry is a positive number)the calculations reduce the number and I would like the display cells to change to red when the contents reaches zero or negative.I'm not even sure if it is even possible, but any help would be appreciated.

David

  compumac 29 Nov 12

Yes. I use this on one my spreadsheets but will have to come back later this evening as I am just on my way out.

  compumac 29 Nov 12
Answer

Excel 2007? Select range. Conditional Formatting/Highlight Cell Rules/Less than and choose colour of formatting.

Check back later.

  Taurus 02 Dec 12

Thank you Compumac, will give that a go. Once again, thanks for responding.

Dave

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message