From: AJK on
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.
From: Roger Govier on
Hi

Almost there.
Just use =P9=P8
--
Regards
Roger Govier

AJK wrote:
> 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.
From: ANOOP on
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?
--
ANOOP MADHAVAN NAIR


"AJK" wrote:

> 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.