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
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Conditional cell colours in Excel - help please


Taurus
Resolved

Likes # 0

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

Like this post
compumac

Likes # 0

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.

Like this post
compumac

Likes # 0

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

Check back later.

Like this post  
Taurus

Likes # 0

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

Dave

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

4G to get faster and cheaper with Freeview spectrum: We're in for a wait though

IDG UK Sites

Apple's 2014: A reflection

IDG UK Sites

Artist creates a geometric rave in a chapel for The House of St Barnabus

IDG UK Sites

Mac mini (Late 2014) 1.4 GHz review: Mac mini is sort of upgradable, but is it any good as it is?