In Calc, version: 4.4.2.2 and 4.2.8.2. Column B contains a formula which results in the cell containing “Yes” or empty. Column I cells contain a date or empty.
In conditional formatting the formula '$B2="" ’ makes the empty rows change colour and the formula ‘AND(TODAY()-$I2>1900,$I2<>"")’ changes the row colour for dates over 5 years. However I can’t get them to work together.
Any help would be greatly appreciated.
Hi
Your formula for calculating dates over 5 years is based on years of 380 days, it is surprising … You can use:
EDATE(TODAY(); -60).
Otherwise, to answer your question uses only one condition:
AND($B2="";$I2<EDATE(TODAY(); -60))
Replace AND with OR depending on whether you want both conditions are met to apply the format or if one is enough