Hi all,
Hope everything is great and everyone are safe at home!!
Could anyone please help out on one of my request as mentioned below.
Attached is the "Sample" spreadsheet for my explanation.
My requirement is that,
I have entered hours on each date that I worked upon on each task (Column 'A') everyday. And in the Column 'A' (Task), whenever "Vacation" exists, when I enter any value (Like 4 or 8 etc etc), the cell color has to be changed to red with the value entered on that particular date.
In the attached spreadsheet, I have shown manually like how it has to appear.
Could anyone please help me out on adding a formula (Like using Conditional Formatting or any other option) such that the cell color has to be changed automatically when entered the value under Vacation Task on any of the date.
Thanks a lot in advance for your time and efforts!!!
Bookmarks