Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

Conditional Formatting for Due dates of payments and received payments

I want to highlight a cell in red if the payment due date has passed but highlight in green if the payment has been made. Payment due date is in one column and payment received date is in another, how do I do this?

MacBook Air

Posted on Mar 13, 2018 5:40 AM

Similar questions

Numbers - Date formulas - Due date Hi, I want a line or text to turn red (background color or text color) if a date is due. Column Q = Invoice date Column S = Paying terms Column U = Due date (formula from Q+S) Column Y = Yes if paid or unfilled if not paid Column W = Today's date I want a specific row to change color if due date has passed accordingly to today's date and if I have not written Yes in column Y. So, in my brain the formula should look similar to: If U has passed W make text on this row into red color and bold, unless column Y says Yes. If column Y is saying Yes, don't do anything to this row. This formula has to work the other way around as well, in case it has turned red and I then type in Yes in column Y, the row should go back to normal state, which is font in black and normal. Anyone who can support me with this one?
621 1

2 replies

There are no replies.

Conditional Formatting for Due dates of payments and received payments

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up