Formating cell by Comparing two cells for value

A

AJK

I have a column of data and I want to use conditional formating to compare
the current cell with the one above. If the cell above is the same as the
current cell I want to fill in the cell with a color. I have tried using an
IF function in the condition formating but it does not seem to work. I tried
=if(p9=p8) and set formating to fill the cell but it say invalid formula.
This has to be simple but I am missing something. Thanks for the help.
 
A

ANOOP

I want to first locate a set of similar machine part numbers entered in two
different work sheets and then save them in a seperate sheet.Could you please
guide me how I can accomplish this with Excel 2003?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a cell if another named cell is blank 2
Conditional Formating 1
conditional formating 1
Copy addition formula of non-consecutive horizontal cells 2
Comparing data sets with +/-1 tolerance using conditional formatin 2
Highlight cells 1

Top