Conditional formating

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

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

Formula:

Please Login or Register  to view this content.