Corrina
05-22-2017, 08:39 PM
Hi,
This is my first time posting so please be gentle!
I have two sheets relating to invoices named Current and Paid.
I'd like to do a few things
1. When I enter data into the sheet named Current, it highlights the row to remind me it's to be paid.
2. When I enter a date into the the Paid column of the worksheet (column 9):
a) the highlight is removed
b) the row is moved to the next available row in the worksheet named Paid and the blank row created in the worksheet named Current is deleted (data moved up).
I can highlight and remove the highlight using conditional formatting using COUNTIF however am unsure of what to write to read a date (1/1/17) rather than text.
Any assistance will be greatly appreciated.
Many thanks,
Corrina
This is my first time posting so please be gentle!
I have two sheets relating to invoices named Current and Paid.
I'd like to do a few things
1. When I enter data into the sheet named Current, it highlights the row to remind me it's to be paid.
2. When I enter a date into the the Paid column of the worksheet (column 9):
a) the highlight is removed
b) the row is moved to the next available row in the worksheet named Paid and the blank row created in the worksheet named Current is deleted (data moved up).
I can highlight and remove the highlight using conditional formatting using COUNTIF however am unsure of what to write to read a date (1/1/17) rather than text.
Any assistance will be greatly appreciated.
Many thanks,
Corrina