Forum Discussion
xhaven80
Aug 22, 2023Copper Contributor
Color checkbox cell based off checked/unchecked box and date due in Excel
I want the cell with the checkbox to be colored based on checked or unchecked and based off of the date that it corresponds to i.e., G2 is unchecked and F2 is a past date so G2:G6 and H2:H6 sho...
xhaven80
Copper Contributor
@mtarler "in theory you don't have to change those formulas or worry about the columns, you just need to assign each of those checkboxes to their corresponding cells and change the font color on those cells."
I formatted the checkboxes in my sheet that didn't have your formulas. I got you. I noticed that the "FALSE" appears but not the true. Where in your syntax does that reference that to be invisible?
mtarler
Aug 24, 2023Silver Contributor
To make the "FALSE" "invisible" you need to highlight those cells and change the TEXT COLOR to match the present background color.
When you click on a checkbox it will turn that FALSE to be TRUE. I suspect you don't see that TRUE in my file because the conditional formatting rules I set up change the background color AND the text color.
When you click on a checkbox it will turn that FALSE to be TRUE. I suspect you don't see that TRUE in my file because the conditional formatting rules I set up change the background color AND the text color.