PDA

View Full Version : Conidional formatting another cells IF CheckBox is checked


Pajoooo
Mar 17, 2016, 04:30 AM
I have a macro that change checkbox caption font color when checkbox is checked. How conditional formatting cells C2,D2 AND B3 in same manner.

Roel Zylstra
Mar 17, 2016, 08:57 PM
It will be easier (and safer) for us to help if you show your formulas and macros within your question description.

Pajoooo
Mar 18, 2016, 12:28 PM
It will be easier (and safer) for us to help if you show your formulas and macros within your question description.

Thanks for the interest, but I have attached a file that is not protected. In the meantime, I have found a solution, the key is in the ActiveX Combobox's Linked cell (ACB Properties), and then on the basis of TRUE, FALSE value in the Linked cell set up conditional formatting.