Color Conditions

[Vikas_Salvi]

In Excel Datasheet column A is a units no. and there status of unit no is in column s "Available & Sold"
if the data any unit status change available to Booked than its change to red color.

the same color must be reflected to same unit is an another sheet.

 

[p45cal]

The attached uses conditional formatting in rows 3 to 10 of the Inventory sheet.
It shows red if Booked, green if Available and no formatting if anything else.
It uses column E from the Data sheet, not column A, and the Status column (N) not column S, "Available & Sold" (which doesn't exist).

 

[Vikas_Salvi]

The attached uses conditional formatting in rows 3 to 10 of the Inventory sheet.
It shows red if Booked, green if Available and no formatting if anything else.
It uses column E from the Data sheet, not column A, and the Status column (N) not column S, "Available & Sold" (which doesn't exist).

Thank You.... for the support