Conditional Formatting based on Checkbox

[chester1993]

Hello all.

I have Sheet1 where I want to put data on cells B2:E20. I want to place a Conditional Formatting on these cells.
Basically, I want to fill the cell if a data is entered - doesnt matter what data, I will put something in that cell.
However, the fill color on the cell will be dependent on my 2 form checkboxes.

Checkbox1 - Green
Checkbox2 - Blue

I have tried the link cell - True or False method. But, I cant seem to make it work. When the checkbox is tick, all cells (B2:E20) will be filled instead of the only cell that I put data in.

I hope someone can help me. Thank you!

 

[GraH]

What is the linked cell of both checkboxes?
What is the CF condition?

 

[chester1993]

Hi @GraH .

Checkbox 1 - linked to A21
Checkbox 2 - linked to A22.

For CF condition, basically any value on that cell. It could be number, could be letter. What matters is the cell will be filled if either of checkboxes is ticked.

Thank you!

 

[GraH]

Are you after this then?
Select B2 and then create the conditional formatting formula.

Book1
	A	B	C	D	E	F	G	H
1
2		a	v	1	>
3
4
5
6			x
7
8
9
10				z
11
12
13		1
14
15				4
16
17					4
18
19
20
21	TRUE
22	FALSE
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E20	Expression	=AND(B2<>"";$A$22)	text	NO
B2:E20	Expression	=AND(B2<>"";$A$21)	text	NO