Forum Discussion

jtriggs1941's avatar
jtriggs1941
Copper Contributor
Nov 08, 2023
Solved

Conditional Formatting highlighting one cell based on comparing 3 other cells

 

I would like to set up a spreadsheet for my budget. I have a dropdown list (E2) with my paydays listed with a cell beside it (F2) adding 13 days. This gives me the time frame that specific pay needs to cover (From/To). Then I have my bills (Company Names) listed in column A (A4:A26) with the amounts in column C (C4:C26) and the due dates in column E (E4:E26). I would like each amount (Column C) to turn red if its due date (Column E) falls between the From & To dates (E2:F2). Any ideas?

 

Thank you,

Terri Riggs

  • jtriggs1941 

    =(E4>=$E$2)*(E4<=$F$2)

    This is the rule for the conditional format which works in my sheet.

    =$C$4:$C$26

    This is the range the conditional format applies to.

Resources