Forum Discussion

Krazy_Cheetah's avatar
Krazy_Cheetah
Occasional Reader
Dec 22, 2025

Cell Color Change

Hello,

Sorry if this has been answered or is super easy but I couldn't find how to do this so I figured I would ask here. Is there a way for me to have a cell be blue normally, but turn green when clicked, and then back to blue when clicked again? I am using a sheet to track weekly check-ins and want to have an easy at a glance way to tell if I did them by color, and set it with a single click. Any help would be appreciated.

 

Thanks

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    You may need to use VBA coding. Alternatively you may try Focus Cell feature to focus active cell.

Resources