Related:
- How to make a cell change colour
- Crimping colour code - Guide
- How to change idm language - Guide
- Change computer name cmd - Guide
- How to change language in kmplayer - Guide
- How to change your best friends list on snapchat to 3 - Guide
5 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 2, 2009 at 04:33 AM
Jun 2, 2009 at 04:33 AM
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
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
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.
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.
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 5, 2009 at 06:39 AM
Oct 5, 2009 at 06:39 AM
Check the link below to study how to do conditional formatting
https://www.contextures.com/xlcondformat01.html
https://www.contextures.com/xlcondformat01.html
lab79
Posts
1
Registration date
Wednesday September 29, 2010
Status
Member
Last seen
September 29, 2010
8
Sep 29, 2010 at 10:05 PM
Sep 29, 2010 at 10:05 PM
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??
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??
Didn't find the answer you are looking for?
Ask a question