Forum Discussion
jtriggs1941
Nov 08, 2023Copper Contributor
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
=(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.
- OliverScheurichGold Contributor
=(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.
- jtriggs1941Copper Contributor