| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell value comparison w/ cell insertion
I have a spread sheet that compares values in Columns B & C - If they match
Column A turns green and reads 'verified' (conditional formatting). If they do not match - I need column C, D, & E to insert blank cells and move the information down one row to continue the comparison between rows B & C and continue this process of being verified or inserting blank cells to the bottom of the columns with values. I am not sure if this would take a Macro, formula, etc.? Can someone help me with this? -- Thanks for your help! Susan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Position insertion point at beginning of cell when editing | Excel Discussion (Misc queries) | |||
| COUNTIF, criteria is cell-to-cell comparison | Excel Worksheet Functions | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Using a Cell Operation for insertion into a Formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
