fram-Conditional formating

[asheshrocky]

Hi All,

I need some help to frame conditional formating for below given scenario.

Please Login or Register  to view this content.

1. Range strart must always be greater than RangeEnd,But i also need to take care of comparator in column E.

Please Login or Register  to view this content.

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

[TonyB51]

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