SOLVED

# Conditional Formatting highlighting one cell based on comparing 3 other cells

Copper 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

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Conditional Formatting highlighting one cell based on comparing 3 other cells

``=(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.

# Re: Conditional Formatting highlighting one cell based on comparing 3 other cells

Thank you.

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: Conditional Formatting highlighting one cell based on comparing 3 other cells

``=(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.