On the Home tab , click on the Conditional Formatting button and select New Rule.
Click on the last option : Use a formula to determine which cells to format.
The formula entry box will be displayed beneath the label : Format values where this formula is true:
If there are no blank cells in your range , you can select the entire data range and format it for a particular color.
Then have only one CF rule for the second color.
You cannot have two colors with only one CF rule.
If you want to have both colors using CF rules , then you need two CF...
The reference in the Conditional Formatting formula has to be relative , and it has to be the top left cell in the range.
Thus , if your data range is J17:M33 , select this range first.
In the CF formula box , enter the formula =J17 = "Sun" , and select the desired color.
Add a second...
Regarding your problem of not being able to upload your workbook , this forum has a file size limitation ; only files which are less than 1 MB in size can be uploaded.
To upload larger files , you will have to use some public file sharing service such as DropBox.
However , before you...
This link shows the chart in the OP , I think :
If you confirm that these intervals have been marked correctly , then can we take the first interval and discuss what is required ?
The first interval is the period from 06.11.19 00:00 to 06.11.19 01:59.
In this interval if we see how many times the value in column B was less than...
I am uploading a part of your full workbook , with only the relevant 4 columns of data , sorted in ascending order on the date and time.
I have highlighted the start and end of each 120 minute interval ; can you confirm that this is correct ?
Where is the attachment please ? I downloaded the most recent upload , and the data appears to be in descending order , from the latest date and time downwards to the earliest date and time.
Anyway , can I sort the data in ascending order , from the earliest date and time to the latest...
I am not clear on what is required.
First , what is the table on the tab named Off days ? Which employee does it refer to ?
Second , you have 31 staff members ; will you have 31 tabs for them , one for each staff member ?
Third , you have created a tab for employee Sam ; will what ever...
Thanks for the upload.
I assume that we need to look at only columns A , B , C and D.
First , the times in column A are in descending order ; can we sort the data so that these times are in ascending order ?
No , it does not mean that.
What it means is that if you post your question in more than one forum , then post links to all the forums where you have posted your question in every forum.
Thus , if you have posted your question in forums A , B and C , in forum A where you have posted your...