|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th, 2010, 09:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating cell by Comparing two cells for value
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. 
|
|
#2
March 11th, 2010, 08:27 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formating cell by Comparing two cells for value
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.
|
|
#3
March 11th, 2010, 12:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formating cell by Comparing two cells for value
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
