Hello friends, hope you are all well!
The calendar attachment here has 2 sheets: 1. “Availability”. And 2. “Car Reservation”.
I want to place formulas in sheet “Availability” cells F14:T16. The result of the formula will show a number between 1 to 9, based on the results. And the conditional formatting will color the cell based on the results (between 1 to 9).
OK the formula will:
a. Will go to 'Car Reservation' and look in $F$2:$F$995 and if it is <= than date in “Availability” F$12.
b. Will go to 'Car Reservation' and look in $G$2:$G$995 and if it is >= than date in “Availability” F$12.
c. Will go to 'Car Reservation' and look in !$H$2:$H$995 and if it = $C14 in sheet “Availability”.
d. And if 'Car Reservation' and look in $i$2:$i$995 = VACATION & COMITEE, then the result will be 7.
And so on, like the 'row 3' results and conditions of sheet “Availability”. so the cell will have
I really appreciate your kind help and thank you very much in advance!
Bookmarks