conditional formatting a live document

Hi there, Are you available now to chat?

Hi Again,  I just realized your time is not the same.  I'll try back again later tonight.

Hello and welcome to ExpertHelp.com! My name is Mario V. and I'm going to do everything in my power to answer your question to your full satisfaction!

Before we get started, I want to remind you ExpertHelp.com is an independent professional support company. We are not associated with Microsoft nor are we paid to provide support on their behalf. However, we have helped hundreds of customers with similar questions and believe we can help you too. OK, let’s get started! :)

I’m available to chat now. Please let me know that you are ready by posting a response. I’ll leave my chat session open for the next 15 minutes or so and wait for your reply. If I don’t catch you this time, please respond with a few times (including your timezone) that work best for you and we can connect then.

So that I could help you, could you please describe your issue in detail? Do you have some cells that need to be formatted when other cells are updated automatically? Are they updated by formula or manual entering?

Thank you.

Notes:

- customer has been called and scheduled a callback in 4 hours from now

Hi Gary,

Here is my email address: e**o@outlook.com

Looking forward to hearing from you,

Mario

 Email support:

Fortunately I have solved the problem relating to conditional formatting but I have another project im currently working on

I want a spread sheet where flights are booked in by airport staff using a vba user form which then populates a data base which has slicers so it can be sorted easily

I also need the spreadsheet to allow the user to cancel a flight and log which airport staff member cancelled the flight

Solution sent to the customer's email.

Email support - customer's response:

"thank you so much this is exactly what i wanted i will present it to my boss and if i need any changes i will contact you

once again thank you so much for your help your a life saver !!"