If less than - Highlight differencies?

[simbacubs]

Hi

I have a simple 4 column excel sheet.

Column A - Part Number
Column B - Cost Price
Column C - Min Sales Price
Column D - Current Sales Price

Because there are over 3000 rows, I would like to know if I can perform the following please...

If Column D is less than Column C highlight the part numbers which are different or highlight it in some way so that I can quickly eyeball the sheet and find out which one differs.

Is this possible? Any help would be appreciated.

Regards

[contaminated]

Try this one. Highlight column D and go to Format > Conditional Formatting, select formulas from first drop down and type there this formulae

=$D1 < $C1

[simbacubs]

Fabulous! Thanks very much, appreciate it.