Hi All,
I need some help to frame conditional formating for below given scenario.
D E F G H
RangeStart comp Default comp RangeEnd
1 <= x <= 5
4 < x < 13
13 < x < 22
23 <= x <= 30
30 < x <= 40
1. Range strart must always be greater than RangeEnd,But i also need to take care of comparator in column E.
D E F G H
RangeStart comp Default comp RangeEnd
1 <= x <= 5
5 <= x < 13
In above scenario the value 5 can be included in both as we have used <= symbol in both cases,thus this is wrong assumption,i want to display the value in column D in red whenever user enter similar entries.
2. The value in RangeEnd should always be greater than value in RangeStart.If not display value in RangeEnd in red.
Thanx
Bookmarks