Forum Discussion
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 nee...
=(E4>=$E$2)*(E4<=$F$2)This is the rule for the conditional format which works in my sheet.
=$C$4:$C$26This is the range the conditional format applies to.
=(E4>=$E$2)*(E4<=$F$2)This is the rule for the conditional format which works in my sheet.
=$C$4:$C$26This is the range the conditional format applies to.
