Is there a formula to have excel return a value iff a relevant cell is highlighted (or contains specific text, either will work)?
I want D2 to return the value in the amount column (since it's conditionally formatted to highlight cells with CC), but leave D3 blank with the same formula.
