Hello Everyone,
I am using a spreadsheet to issue a pass or fail result for test I perform on hoses. I select Pass or Fail from a standard name defined list but I want the Pass to be the color Green and Fail to be in Red. Simply coloring the name defined cells accordingly as you know does not work as I found out...
I use a macro to save the file, print out the report, drop the data into the database and clear the required cell contents ready for the next test info.
If I can incorporate a formula in the macro to change the color accordingly I would be very happy.
Thank you in advance for your assistance...
I am using a spreadsheet to issue a pass or fail result for test I perform on hoses. I select Pass or Fail from a standard name defined list but I want the Pass to be the color Green and Fail to be in Red. Simply coloring the name defined cells accordingly as you know does not work as I found out...
I use a macro to save the file, print out the report, drop the data into the database and clear the required cell contents ready for the next test info.
If I can incorporate a formula in the macro to change the color accordingly I would be very happy.
Thank you in advance for your assistance...