|
Guest Services Site Questions, a tech query or just want to test something. |
|
Thread Tools | Search this Thread | Display Modes |
18 Oct 17, 03:53 PM |
#1
|
|
VIP Dibber
|
Anyone a whiz on Excel
Hi All,
Does anyone know how I can set up a conditional format for a spreadsheet I have with dates in that I need it to go red within 30 day of the date in the box? Basically I have a spread sheet of when a task is due which could be today or any date in the next 3 months but when I open the spreadsheet I want it to show in red anything that is due to expire in 30 days? Thanks in advance
__________________
WDW Visited in 1992, 1995, 1997, 1998, 2004, 2005, 2007, 2008, 2010, 2011, 2013 |
|
|
18 Oct 17, 06:26 PM |
#2
|
|
Imagineer
|
in cell with date click on conditional formatting and chose date occurrence and chose option
|
|
|
20 Oct 17, 12:12 PM |
#3
|
|
Imagineer
|
The problem with that it there's no option for "within the next 30 days" to select - at least there isn't on my version of Excel. There's options for "This Month" and "Next Month" but those aren't the same thing.
The way I'd do it is as follows: (Disclaimer: this is probably not the best way to do this) 1. Select the cells with the dates in that you want to perform conditional formatting on. 2. Click on "Conditional Formatting" in the toolbar, then "Highlight Cell Rules", and then "Less Than...". 3. In the pop-up dialog box, enter "=TODAY()+31" (without the quotes). Select the type of formatting you want - eg. Light Red Fill. Click "OK". 4. With the same cells still selected, click on "Conditional Formatting", then "Highlight Cell Rules", then "Greater Than...". 5. In the pop-up dialog box, enter "=TODAY()+30" (without the quotes). Select the type of formatting you want - eg. Green Fill. Click "OK". 6. Days equal to or less than 30 days from today's date will be coloured red. Days further away than 30 days from today's date will be coloured green. Remember to put the equals sign before TODAY(). Hope that helps and is what the OP wanted/meant.
__________________
DLC: Jun 1996 // DLP: Aug 2013 // WDW: Dec 1997 | Feb 2000 | Mar 2001 | Feb 2006 | Oct 2010 | May 2012 | Aug 2014 | Apr 2016 | Apr 2023
~ Trip Report Indexes ~ |
|
|
Thread Tools | Search this Thread |
Display Modes | |
|
DIBB Savings |
AttractionTickets.com
Get £10 off each Disney Ticket with the code ATDIBB10 Get up to £50 off per room at Disney or Universal with the code DIBBHOTELS |
theDIBB Blog |
Disney announced that a new nighttime show, “Disney Dreams That Soar,” will run nightly at... Read More »
Walt Disney World Resort guests can get ready to have a “glowing’’ good time when... Read More »
Aquatica Orlando announce the grand opening of its newest attraction, Tassie’s Underwater Twist, on 15... Read More »
|
theDIBB Menu |
Exchange Rates |
US Dollar Rates
Euro Rates |
DIBB Premium Membership |
Did you know you can help support theDIBB with Premium Membership? Check out this link for more information and benefits, such as... "No adverts on theDIBB Forums" Upgrade Now |