Forum Discussion
Solved
Conditional Formating
I have a spread sheet that tracks Mowing times for our crews. One column states how much time it is supposed to take for each customer. Then other columns have the number of guys on the crew, start...
Hi,
First, you may join all you rules into one. In file I joined two with rule
=(L3>$K3)*(L3<>"")
applying it to
=$L$3:$L$323,$AF$3:$AF$323
Second, your time is only looks the same. If you copy AF92 and AK92 (both 1:24) and paste as values it'll be 0.0583333333333333 and 0.0583333333333335.
You may round the cells formatted as time to 1 second as
=MROUND(<cell>,"0:00:01")
See for AF and AK columns
Hello,
Not here for the answer, just wanted to point out that no files with personal info should be uploaded since this is clearly an infringement of data protection.
You don’t just have names and contact info there, but gate codes and where house keys are hidden..
Not to mention comments on clients.
You should take it down and just upload a sample with bogus data.
Best!
Not here for the answer, just wanted to point out that no files with personal info should be uploaded since this is clearly an infringement of data protection.
You don’t just have names and contact info there, but gate codes and where house keys are hidden..
Not to mention comments on clients.
You should take it down and just upload a sample with bogus data.
Best!