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.
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.
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.
All times are GMT -7. The time now is 02:13 AM. |