Hello,
I'm looking for a conditional format setting to highlight cells that have not yet received a posted payment.
Cell M12 = Total Invoiced Value
Cell N12= Total Collected Value
I'd like for N12 to highlight in red when the total collected is less than the total invoiced. If its equal or greater, no formatting required.
I'd also like to N12 to be clear if M12 is blank (i.e. no invoice issued).
Thank you,
I'm looking for a conditional format setting to highlight cells that have not yet received a posted payment.
Cell M12 = Total Invoiced Value
Cell N12= Total Collected Value
I'd like for N12 to highlight in red when the total collected is less than the total invoiced. If its equal or greater, no formatting required.
I'd also like to N12 to be clear if M12 is blank (i.e. no invoice issued).
Thank you,