Conditional formating

[ShadowRider]

I would like to set a row's color to a pale red when row's data from either or both columns B or D have data and values from C and E are not the same.

Advice to achieve this conditional formatting is appreciated.

Thanks

[jewelsharma]

select all applicable rows, and use the following formula in Conditional Formatting; and select the desired fill color:

=AND(OR($B1<>"",$D1<>""),$C1<>$E1)