Active command button color change if certain value present in column of another sheet
i have active command button in sheet1 and when i click the button it goes to a form and form saves data into sheet2.
i wont the button color to be change to different color when i save the form and data is in the column of sheet2.
can anyone help please
thank you
Bookmarks