What I have is a daily report for a motel. Guest’s names are put into column B and their room charge is put into column D on the same row.
To make sure the night auditor is accounting for every rented room they have to either enter the guest name in Column B or put a V (for vacant) in the cell to acknowledge that they have checked to see if the room was occupied.
A common mistake is to enter the guest name but forget to enter the room charge in column D.
What I want to happen is for column D to change color only if anything except V is entered into column B of the same row to remind them to enter the room charge.
Then I want the color to in column D to disappear when they enter the room charge in that column.
Thanks,
Dave
To make sure the night auditor is accounting for every rented room they have to either enter the guest name in Column B or put a V (for vacant) in the cell to acknowledge that they have checked to see if the room was occupied.
A common mistake is to enter the guest name but forget to enter the room charge in column D.
What I want to happen is for column D to change color only if anything except V is entered into column B of the same row to remind them to enter the room charge.
Then I want the color to in column D to disappear when they enter the room charge in that column.
Thanks,
Dave