Hi all,
Happy Friday! I hope you are well.
I would like to highlight cells using conditional formatting once certain conditions are met. I am attaching a file for better understanding.
Essentially, this involves formatting so that when employees have used 50% or more of their annual leave entitlement, the cell fills in orange. When they have reached 75% or more, the cell fills in red.
D6 should be filled in orange, D7 should be filled in red.
Thanks
Bookmarks