- If the sold date is more than 180 days ago (compared to today) conditional format red
- If the Sold Date is 90 days ago or less (compared to Today) then make green
- If the sold date is less than 180 ago (compared to today) then make yellow
this needs to use a formula. TODAY must be a calculation so that as time changes, the colors of these fields changes
*Tried to use the formula on the right side however, all the cell range turned red