Conditional formatting + input a value

Or you could make it dynamic by adding this formula to cell D2 as seen in new sheet.

Formula:

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

I've updated your file with another example with the solution. You already had CF rules in there that are nearly right, just needed a tweak.

Formula:

Please Login or Register  to view this content.

Perfect!! Thank you so much!

Originally Posted by Flyboy65

Or you could make it dynamic by adding this formula to cell D2 as seen in new sheet.

Formula:

Please Login or Register  to view this content.

My interpretation of this is that rather than just checking that the "Owing" (Col B) value EQUALS the "Paid" (Col C) value, this one actually calculates, is that right?

I love your creativity here - would do me a lot of good to understand it also so that I can use it and learn from it

Phrased another way, can you guys suggest a formula that will simply check if the "Owing" (Col B) is equal to or less than £0.00 and then print a "YES" value in the "Paid in full?" (Col D) field?

This formula in D2 should give you what you are looking for.

Formula:

Please Login or Register  to view this content.