| Home |
| Search |
| Today's Posts |
|
#1
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating comparing the two columns | Excel Discussion (Misc queries) | |||
| Comparing data in 2 cells to create an output for a 3rd cell | Excel Worksheet Functions | |||
| Comparing characters in one cell to multiple cells | Excel Worksheet Functions | |||
| comparing 2 cells where 1 is a cell with a formula | Excel Discussion (Misc queries) | |||
| Comparing cell contents with different reference cells | Excel Worksheet Functions | |||
Linear Mode
