Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing cells
I need to compare the values in two cells and set a flag (preferably
color the cell red) if they are different. There are too many to do visually, so I would like to automate the process. Can a macro be written to check differences? What if I want an intelligent comparison, such as that I want to ignore excess spaces, but not different values...? I may also want to skip some cell comparison based on the value in a third cell..... .This third cell may have a Y or N for compare, or not. How should I approach this? Any help at all would be greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing cells
I would recommend the use of the exact function combined with IF statements and conditional formatting to acheive the result that you want. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=543486 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing cells
Thanks for the help. I found the exact documentation and see how to use
it. But how would I use conditional formatting? For example, I want "thistext" to match with "this text". I want to skip the spaces. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing cells
Got it, I needed a 'substitute' ..Thanks for the help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Cells | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |