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

View Forum Rules | Contact Forum Editor

 

Conditional cell colours in Excel - help please

Taurus
Resolved

Likes # 0

Posted November 29, 2012 at 8:10PM

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

Posted November 29, 2012 at 8:53PM

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

Posted November 29, 2012 at 8:57PM

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

Posted December 2, 2012 at 12:21AM

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.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.