Forum Discussion
Conditional formatting using formula when check box not selected
Can someone please help me with the formula to highlight a cell that does not have the checkbox selected to be red?
Tracey,
Please let us know, do you want to highlight the cell in case of all checkboxes is not selected or if one or more of them are not selected?
The approach is to link each checkbox to the cell behind it, and then depend on the value of the cell in the conditional formatting rule!
The value of the cell will be TRUE or FALSE depending on the checkbox status (checked/unchecked).
If you can provide us with the workbook itself, please do so!
Haytham Amairah wrote:
Tracey,
Please let us know, do you want to highlight the cell in case of all checkboxes is not selected or if one or more of them are not selected?
The approach is to link each checkbox to the cell behind it, and then depend on the value of the cell in the conditional formatting rule!
The value of the cell will be TRUE or FALSE depending on the checkbox status (checked/unchecked).
If you can provide us with the workbook itself, please do so!
We'd like everything highlighted if it is not selected.
Hi Tracey,
Please find the attached workbook, it contains a sample data similar to the data you have.
And the solution in there by the approach I mentioned before.
The formula in the conditional formatting rule is this:
=AND($F2:$I2)
I hope that helps
Haytham
Tracey,
Please see the attached file to test the approach.
Good luck
