Formating cell by Comparing two cells for value
in [Functions]
|
Prev: Averaging every 5th cell while omitting zeros
Next: how can I use conditional formatting with formula and 3 poss resul
From: AJK on 10 Mar 2010 16:12 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 11 Mar 2010 03:27 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 11 Mar 2010 07:17
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. |