Forum Discussion
color cell if the time value for a given unit is within a range
Hi All, I am trying to color the time cells red if the time differnces for a specified unit is less than 10 minutes. For example, for unit 3813 if any of the first, second, third, fourth time va...
jiwanjot , Like below :-
in fact same formula is now applied twice : once on A1 to A15 & then again on A2 to A16
See yellow highlighted in screenshot that follows
A1 to A15 rule : checks self and cell below
A2 to A16 rule : checks self and cell above
In combination, these two rules work fine for continuous cells with time differenc <10min
Here i changed some time values as test case to show it works :-
See modified attachment of this post
and for non-continuous cells, i'm afraid i can think of sorting as only option in excel formulas (i.e. without involving macro programing)
