Excel formula

I deal with appointment and what I want is a formula to say that if one cell says canceled then to strikethrough the appointment and reduce the booking count for that specific client.
EXCELR