Changing colors in cells for ranges

Changing colors in cells for ranges

Alright everyone, I'm creating a spreadsheet at work.
I need dates to change to three different colors:
 
Color 1: Date is 60 days or more in the future
Color 2: Date is between 1 and 60 days in the future
Color 3: Date is today OR past date.
 
I've figured out how to do two different colors, but I can't figure out how to do the color 2.
If anyone has any suggestions or can help me out with this, it would be greatly appreciated.
Thank you.

Solutions to the Problem Changing colors in cells for ranges

Download SmartPCFixer to Fix It (Free)

Use the "Use formula..." option and use this type of logic, where C2 is the upper left cell of the group of cells to be formatted (or just the top) with all cells selected.
 
=AND(C2>NOW(),C2Just as a reference my other formulas are:
=C2=C2>NOW()+59 for the 60 days or more in the future condition

To check for Windows updates

1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Fix the Problem: Changing colors in cells for ranges:

 

 

How to Fix Changing colors in cells for ranges with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed

Related: 1080p setting is gone in Windows Movie Maker After Windows8 1 KB2919355 x64 update installation having issue with the new windows start button and the menu search share start devices and settings is not showing anymore cannot access xp files on my external hd using Windows 7 Automatic Logon to Windows SharePoint Server C Windows svchost exe error message pops up everytime C Users user name AppData Roaming Microsoft Windows Start Menu Programs Startup Autoruns Disabled Computer freezes on boot up on both Windows Vista and after a fresh install of Windows 7 Cannot write message using Outlook Express and Windows Live Mail Daily BSOD s at random on Windows 7 x64 Computer with Windows XP will not recognize Comupluter on Network with Windows 7 Windows 7 sees Computers woth XP but cannont communicate with them Can Microsoft make a Windows 8 only for desktops laptops without the touch screen features Dell Inspiron 15 with Windows 7 having Startup issue with flicking Charms in Windows 8 1 Difference between Windows 7 Pro 32 64 bit to Windows 7 Pro OEM version Bing tabs on Windows Internet Explorer 8 DJ Inkers will not work on Windows 7 Is there a way to make it work,Can favorites be added to my Yahoo toolbar How I m using IE 8 0 6 and Windows 8 ati radeon hd 3200 graphics driver update How can I disable restarting of applications after Windows Update performs a reboot ati radeon hd 4800 driver PC crashed during Windows Experience assessment ati radeon drivers download Share Folders ain t accessible between three Windows 7 Ultimate Computers Pls Help ATI Display Driver Starting Problem with Windows 7 no icons appear ati radeon driver download Windows 7 icons there but doesn t display any words ati Windows old recovery of previous programs creative labs drivers four Make use of the “Tab” critical within the keyboard to select the USB flash drive.
Read More: How to Resolve - page number defines the row of a linked cell - across multiple sheets?,Cumulative totals for budgeting from other cells [Anwsered],[Solution] I need to download I.E. 6 for business use,(this is the program they've suggested.__will this affect Windows XP?,Header not showing using IE & google chrome,Windows 7 Failed to boot with Blue Screen Error.,registry edit or back up,How does my hard drive get fragmented?,Is it possible to shut the lid of your laptop, and not have your computer go into sleep or hibernation?