Conditional cell colours in Excel - help please

  Taurus 20:10 PM 29 Nov 12

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.


  compumac 20:53 PM 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 20:57 PM 29 Nov 12

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

Check back later.

  Taurus 00:21 AM 02 Dec 12

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



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

Best Cyber Monday deals 2015 live blog: Best UK Black Friday weekend deals & best UK Cyber Monday…

1995-2015: How technology has changed the world in 20 years

The best Black Friday Deals for designers and artists – updated

20 Mac Power User Tricks... That You Didn't Know