Excel 2007 - Conditional Formatting of a Row based on a Date and a Text Field
Posted on 2013-11-03
I have a list of invoices with the usual Invoice Number, Invoice Date, Client Name, etc. columns.
I want to change the colour to Red if the value in the Invoice Date column is over 45 days AND if the value in the Paid column is "No".
I was able to figure out how to apply the format change to the Invoice Date column if over 45 days but was unable to add the condition based on the Paid column. And extending it over the whole row? Couldn't figure that out yet...
Anyone able to help me out?
Thanks very much,