Hi there, I am hoping someone can help me with my budget spreadsheet:
A2:A5 contains different dollar amounts, a6 is the sum of those amounts
In column B (B2:B5), i place a "p" beside the amount in column A once it has been paid.
I want to:
a. conditionally format the amounts in column a to turn green once I put the 'p' in the adjacent column
b. conditionally format the sum in A6 to exclude amounts that have been paid, and only display the total amount of the unpaid lines.
thank you!
Laura
Bookmarks