hello friends ,
in sheet 1 i have database of around 300 products .
column A has product name
column B has prices for those products
in sheet 2 , is it possible ? following .....
1) randomly popping up products one by one in column A
2 ) input by user manually price ,
if wrong , cells turns to red color
if right , cells turns to green color
3 ) if wrong , actual price of that product is displayed in next cell in column c
for example i have attach sample data file of 7 products
Bookmarks