Forum Discussion
Change cell colour when current date is greater than one cell date and less than another cell date
Hi, I am creating a spreadsheet to provide information on sports programs throughout the year. I want to include a feature for when a program is open, a cell will fill in green. On the spreadsh...
HoffyC , formula shall be like
=AND(C3 >(TODAY()+30),C3<(TODAY()+60))i.e. you use in it first cell from the range to which conditional formatting is applied ($C$3:$AY$25). With that conditional formatting iterates each cell in the range applying the formula. Since we use relative reference in the formula, internally in formula will be used C3, D3,...AY3, C4,...AY25.
That the same as you enter above formula below you range and drag it down and to the right if you'd like to test returned values.
Brilliant, thank you Sergie, that worked.
Would you be able to help me with the final formula? any date that has expired the cell turns red?
Your help has been exceptional.
You may add one more rule with formula like
= C3 < TODAY()for the "red" formatting.