If Start Time is <=15 minutes from Office Time (IN) then color will be green and Start Time is > 15 minutes from Office Time (IN) then color will be red. please help me on it
If Start Time is <=15 minutes from Office Time (IN) then color will be green and Start Time is > 15 minutes from Office Time (IN) then color will be red. please help me on it
Please go through the attached file
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixthsense,
Thanks for your effort, i have attached the updated file with Example which i want. and conditional formatting will be on column B (Start Time). Sorry for my mistake to understand you.
Sorry, I don't understand what you are trying to achieve
B'cos your conditions and the expected results are contradictory...
I want to achieve the (Start time - Office Time (IN)) is grater than 15 minutes then color will be Red and rest of them Green. Please fine attached file
Please go through the attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks