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