Forum Discussion
Conditional Formating
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
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
When I tried your formula
=(L3>$K3)*(L3<>"")
It made cells that had nothing in them highlighted....would that because I didn't erase the old rule?
So I can make 1 rule to work for all the cells on the whole sheet? I don't have to do a different rule for each column?
Thanks! the MROUND part worked!
In attached file I combined all rules in one. From my point of view when you add new column to highlight it's easier to add another region to the rule rather than generate new rule for each new region.
However, if you are comfortable with your existing rules - keep them, they also work.
- Thank you! That solved it for me!