Conditional Formatting

[DLC]

Hi Everyone,

Kindly please let me know if I can set and conditional formatting to each row.
For ex (as attached file)
I have value in B6 and C6 which will pick the details from D6 and E6
now in the next row I will have the value in B7 and C7 which should pick the value from the D7 and E7

So this continues down. So is there any standard format for this condition. As the data is huge.

Thanks in Advance.

[Marcol]

Try removing the absolute anchors, $, from your cell values

e.g. cell value is
=D6

Then change your "Applies to range" to suit
e.g.
=$B$6:$C$10000

This however will colour orange any blank cells if columns D:E are blank

Is that what you need?

[DLC]

Hi Marcol,

Not exactly what I am looking for.
As I said now I have my data in Column B and C which are depended on Column D and E. This value will change from fraction to decimal. and for instance if there are around 8 rows in Column B,C, D and E
now the rows will be independent. just that the condition will be applied on the lower rows. So that based on the values which are different in D7, D8 and so on the format should reflect.