How to make a cell change colour [Closed]

Report
-
 Jay -
Hello,
i am trying to make a money sheet on excel to sort out my money.

i already have the basice sheet made and i have a sum in the box i want to use. i want to keep the same sum in the cell but i also want to add another to make the cell change colour to green if the amount is above 0 and red if the number turns into a negative below 0

can anyone advise me on this

5 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi
Use 'conditional formatting' and in that
add one condition with cell background colour as red and the formula =CellAddress<0
add another condition with cell background colour as green and the formula =CellAddress>0
46
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Firstly unprotect sheet under tools (if protected). The only way i know how to do this is by applying one cell at the top of the screen first with the following formula applied =TODAY(). This cell will the update daily. Maybe put a bold outline on this box and label it in the cell to the left or right 'todays date'.
Now click on the cell with the date of your meeting, reminder etc.
Now go to Format - Conditional Formatting.
You now have up to 3 conditions that you can apply to a cell. There are various options available (colours, fonts, patterns etc) under various conditions (cell value is greater than, less than, equal to etc).
In the first condition select 'cell value is' - 'greater than' - now type in the grid reference of the cell with todays date followed by the subtraction of the number of days you desire before it changes colour. Example below...
=$A$1-5.
This would then change to your chosen colour 5 days prior to the date.
Now assign the necessary colour you wish it to change to under 'format' - colour' and repeat again for further conditions.
It took me a while to work this one out hope it helps you. Any further advice let me know.
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Check the link below to study how to do conditional formatting
https://www.contextures.com/xlCondFormat01.html
Posts
1
Registration date
Wednesday September 29, 2010
Status
Member
Last seen
September 29, 2010
8
i have had a look at a number of conditional formatting options but can't seem to find what i am trying to do.

i want to change the cell colour of a date as a reminder that that date is important. For example 2 days before the cell date i want it to be orange and then 1 day before the date i want it to turn red.

Is this possible and can anyone help me??
exactly how do you do this? I'm trying to do the same thing but am a Excel noob. Where do I set these conditions and how do I set the condition with the background color change? Thanks.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!