Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Conidional formatting another cells IF CheckBox is checked (https://www.askmehelpdesk.com/showthread.php?t=822918)

  • Mar 17, 2016, 04:30 AM
    Pajoooo
    1 Attachment(s)
    Conidional formatting another cells IF CheckBox is checked
    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.
  • Mar 17, 2016, 08:57 PM
    Roel Zylstra
    It will be easier (and safer) for us to help if you show your formulas and macros within your question description.
  • Mar 18, 2016, 12:28 PM
    Pajoooo
    Quote:

    Originally Posted by Roel Zylstra View Post
    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.