ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Morning,
Working with numbers & having to make a large list.
Before i make a large mistake can you advise a basic code for me please.
The columns in question are W & X
The code will check the number value in the first cell in column W & make sure its the same as in the cell to the right.
The code will check all down my list.
Is the value matches then leave as is BUT if value does not match make cell in column X red
IF NO VALUE IN CELL COLUMN W THEN JUST MOVE ON
Thanks
Working with numbers & having to make a large list.
Before i make a large mistake can you advise a basic code for me please.
The columns in question are W & X
The code will check the number value in the first cell in column W & make sure its the same as in the cell to the right.
The code will check all down my list.
Is the value matches then leave as is BUT if value does not match make cell in column X red
IF NO VALUE IN CELL COLUMN W THEN JUST MOVE ON
Thanks