fram-Conditional formating

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

Hi,

I have attached what I believe you were wanting.

To Test increase the values in Column D or Decrease the last column.

Cheers

TonyB