Googlesheets Conditional Formatting Based on Checkbox from another sheet

1
votes

I have two sheets and on one I have a checkbox that once it is TRUE I want a cell on another sheet to change colour.

I've tried the INDIRECT function as part of the "Custom Formula Is", but I just can't get it to work.

=indirect("Gina Working!H2")="TRUE"

So here, cell H2 on the sheet Gina Working is the cell and sheet that has the checkbox on it. The Custom Cell Values in Data Validation for the checkbox is set to TRUE and FALSE.

I just can't see what I'm missing here. Any help would be great thanks.

1
if-statementgoogle-sheetsformattingconditional-statementsgs-conditional-formatting

1 Answers

1
votes

try like this:

=IF(INDIRECT("Gina Working!H2")=TRUE, 1)