compare values and paste in another woksheet
Hi all,
I have a worksheet that has a column "F" that has a drop down list between cells F24 to F63 with the following options
"crack"
"No Crack"
and a blank value
What i would like to do is sort each of these values and past into a cell in another work sheet
if all cells in the column = No Crack then paste "no Crack" in cell A1 of worksheet 2
if all cells in the column = Crack then paste "Crack" in cell A1 of worksheet 2
if a single cell in the column = Crack then paste "Crack" in cell A1 of worksheet 2
And if the pasted value ="Crack" then i want the cell to have red fill with white text.
Is this possible to do in VBA and if so how.
