Share via

Excel Overview sheet problems

Alex 1 Reputation point
2021-07-29T15:41:46.633+00:00

I have created an excel sheet for my team that uses the a formula to turn cells orange and red as they approach 60 days and 30 days away from; leave of absence, leave for a course and qualifications running out. I have a number of employees in my team and a seperate sheet for each of them.

I want to have an overview sheet with 3 cells in a row that turn red or orange as their main sheet notices they are coming up on leave etc.

Thanks for any help you can give!

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,191 Reputation points Microsoft External Staff
    2021-07-30T05:55:30.897+00:00

    Hi @Alex ,
    Based on your description you're looking for Conditional Formatting solution:

    https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

    I suggest you provide a sample or screenshot about your problem, please be a bit more precise to explain your requirement so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.