Thread: [Solved] Conditional formatting
View Single Post
 
Old 03-02-2015, 09:40 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by bbutl027 View Post
I have done this but all the cells are coming up yellow. Unless I have entered them wrong. I have entered the following dates just to check the conditional formatting.

A1: 3/4/14
A2: 4/4/14
A3: 5/4/14
A4: 6/4/14

With conditional Formatting:

cell value less than =today()+365-90 yellow
cell value less than =today()+365-60 amber
cell value less than =today()+365+30 red
cell value greater than =today()+91 green

This is correct?
You have to make sure you have the order right for the conditions. Also I'm not entirely clear on those equations as I've had a few adult beverages. Attach your file and I'll take a gander tomorrow.
Reply With Quote