actual v estimates with color coding
I have fields for 'estimated value' and 'actual value' for each quarter. So 8 fields total.
'Estimated values' are populated for all 4 quarters at the beginning of the year.
'Actual values' are populated after each quarter ends.
What I'd like to do is calculate the 'estimated' YTD based on today's date. So if today is april 1, then sum Q1 estimate. If today is July 4, then sum Q1 estimate and Q2 estimate. Then compare that answer to 'actual YTD' (which i already have a formula for). If negative number, color row red. If positive number, color row green.
------------------------------
J G1987
------------------------------
'Estimated values' are populated for all 4 quarters at the beginning of the year.
'Actual values' are populated after each quarter ends.
What I'd like to do is calculate the 'estimated' YTD based on today's date. So if today is april 1, then sum Q1 estimate. If today is July 4, then sum Q1 estimate and Q2 estimate. Then compare that answer to 'actual YTD' (which i already have a formula for). If negative number, color row red. If positive number, color row green.
------------------------------
J G1987
------------------------------