Highlight consecutive 7 days or above using conditional formatting
Hi there! I'm new here. Please give a helping hand! :P
As I am working on a excel file to record staff's annual leave, is it possible to highlight a staff who took a consecutive 7 days or above annual leave by using conditional formatting?
Thank you in advance.
For Column D conditional format done.
Formula for D3
Select D3:D47
Please Login or Register to view this content.
In the Cf dialogue box Enter the formula an d format as required.
Last edited by kvsrinivasamurthy; 07-01-2018 at 06:02 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you for your masterpiece! It works well.
"Sorry to bother again. Is this formula works in a row as well? I tried but it couldn't."
Problem solved after formula amendment.
Last edited by kyleung; 07-01-2018 at 07:45 AM.
Try this formula
Formula:
Please Login or Register to view this content.
May I know what was the amendment.Formula was meant for a single column as per your file.
Last edited by kvsrinivasamurthy; 07-01-2018 at 09:26 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks