Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a formula which places a background onto a cell when the date is less than today - which is working fine.
= if(Sub_Contract_End_Date <= Today(), YELLOW())
How do I amend to pick up dates greater than today and have a differing colour for them, i have got to the below but cant think of how to introduce an OR statement
= if(Sub_Contract_End_Date <= Today(), YELLOW())= if (Sub_Contract_End_Date => Today()+30, RED())
May be as below:
= if(Sub_Contract_End_Date <= Today(), YELLOW(), if (Sub_Contract_End_Date >= Today()+30, RED() ))
Hi Martin,
I think this would do, try it .
= if(Sub_Contract_End_Date <= Today(), YELLOW(), RED() )
Please Try this
= if(Sub_Contract_End_Date <= Today(), YELLOW(), if (Sub_Contract_End_Date >= Today(), RED() ))
Hi Martin,
Try this,
= IF(Sub_Contract_End_Date <= Today(), YELLOW(),
IF(Sub_Contract_End_Date >= Date(Today()+30), RED()))
try below
Hi All
Unfortunately these formulas are highlighting all future dates in RED as well when I actually only want the dates 30 days from todays date. I was thinking something like the below might work but cant get the formulas right:
'>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30
Thanks
May be as below:
= if(Sub_Contract_End_Date <= Today(), YELLOW(), if (Sub_Contract_End_Date > Today() AND Sub_Contract_End_Date <= Today()+30, RED() ))
Try This,
1. below todays dates are yellow and 30th day from today only is red.
= IF(Sub_Contract_End_Date <= Today(), YELLOW(),
IF(Sub_Contract_End_Date = Date(Today()+30), RED()))
2. This only for 30 days date in red from today.
= IF(Sub_Contract_End_Date <= Today(), YELLOW(),
IF(Sub_Contract_End_Date <= Date(Today()+30 and Sub_Contract_End_Date > Today()) , RED()))