I need to produce one report for system performance for that i inserted drop down list(ActiveX)with three values OK,Corrective action taken,Outage found.
I feel that if i select OK the background of Drop down list should be in Green,Corrective action should be in yellow,Outage found should be in Red then it would be a effective report.
I don't know the Macro or VB stuffs.
Please any one guide me how to achieve this or Please give the exact Macro.
Thanks in advance.