CODEWITHSUNDEEP
if-statementgoogle-sheetsformattingconditional-statementsgs-conditional-formatting
Les McQueen
Les McQueen

Reputation: 27

Googlesheets Conditional Formatting Based on Checkbox from another sheet

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.

Upvotes: 1

Views: 451

Answers (1)

player0
player0

Reputation: 1

try like this:

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

Upvotes: 1

Related Questions