Notices
Guest Services Site Questions, a tech query or just want to test something.

Reply
 
Thread Tools Search this Thread Display Modes
Old 18 Oct 17, 03:53 PM  
Link to this Post
#1
Disneymaddaddy
VIP Dibber
 
Disneymaddaddy's Avatar
 
Join Date: Jul 10
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
Disneymaddaddy is offline Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Old 18 Oct 17, 06:26 PM  
Link to this Post
#2
barryp1
Imagineer
 
barryp1's Avatar
 
Join Date: Aug 10
in cell with date click on conditional formatting and chose date occurrence and chose option
barryp1 is offline Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Old 20 Oct 17, 12:12 PM  
Link to this Post
#3
Nimbus
Imagineer
 
Nimbus's Avatar
 
Join Date: Jul 10
Location: South Manchester

Nimbus's Reviews
Hotel Reviews: 8
Restaurant Reviews: 21

theDIBB Guidebook
Guidebook Photos: 36
Guidebook Reviews: 2
Originally Posted by barryp1 View Post
in cell with date click on conditional formatting and chose date occurrence and chose option
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 ~
Nimbus is online now Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Forum Jump


All times are GMT +1. The time now is 01:35 PM.


Powered by vBulletin - Copyright © 2000 - 2024, Jelsoft Enterprises Ltd.
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
ASDA  $1.2342
CaxtonFX  $1.2306
Covent Garden FX  $1.2431
FAIRFX  $1.2350
John Lewis  $1.2380
M&S  $1.2178
Sainsburys  $1.2337
TESCO  $1.2343
Travelex  $1.2353
Updated: 12:30 28/03/2024
Euro Rates
ASDA  €1.1426
CaxtonFX  €1.1407
Covent Garden FX  €1.1513
FAIRFX  €1.1432
John Lewis  €1.1457
M&S  €1.1263
Sainsburys  €1.1419
TESCO  €1.1425
Travelex  €1.1435
Updated: 12:30 28/03/2024

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



X