Radio button, activate, highlight cells?

[doctortt]

Is it possible to do this?

If a user select this radio button on the excel sheet, Excel will automatically change the color of the cells?

Then if a user de-select this radio button, the color of these cells disappear?

[mikerickson]

It could be done with VBA, but a non-VB approach would be to link the option button(s) to a cell ($E$11 in this example) and then have Conditional Formatting on the row in question with formulas like =($E$11=1) to determine which color it should be.

[doctortt]

It could be done with VBA, but a non-VB approach would be to link the option button(s) to a cell ($E$11 in this example) and then have Conditional Formatting on the row in question with formulas like =($E$11=1) to determine which color it should be.

Thanks a lot

[doctortt]

Hi

Is it possible to have a user to click a button on the Excel sheet and Excel will automatically play an EMBEDDED wav file (without opening windos media player?)

Thanks