Excel help. Highlighting cells

[mattyg]

Hi guys,

I've created a spreadsheet with old prices (Column) vs new prices (Column) Prices are on separate lines
I want to highlight cells that are the same so if any products haven't increased in price we can see it at a glance.

Old price New Price
£3.45 £3.50

Any ideas

 

[PaulM]

Conditional formatting? Highlight the two columns -> Conditional formatting -> New Rule -> Use a formula to determine which cells to format -> enter the formula based on the two columns (i.e. =B1=C1 if you had the two numbers in columns B and C and wanted to check for equality, or =B1<=C1 if you want lower or equal) -> Set the colour you want it to show as