Conditional formatting - Value from a differnet cell

[trevolly]

Hello All

I have a table made with tasks in it and I was hoping that excel could shade the tasks when they are ticked off (Cells H6 to H21). I have made check boxes and then put a cell link in to a different cell (G6 to G21 with a True / False value), which I will eventually hide. Can I ask how I then set a conditional format command to colour shade a different cell (H6 to H21 depending on the TRUE / FALSE value of the other cells?

 

[Toadstool]

Hi Trevolly,

A Conditional Format is set when the result is TRUE so in this case you just need to point to the same row in G

Book1
	F	G	H	I
5
6		TRUE
7		FALSE
8		FALSE
9		FALSE
10		TRUE
11		FALSE
12		TRUE
13		TRUE
14		FALSE
15		TRUE
16		TRUE
17		FALSE
18		FALSE
19		FALSE
20		TRUE
21		TRUE
22
Sheet1

Cell Formulas
Range	Formula
G6,G20:G21,G15:G16,G12:G13,G10	G6	=TRUE
G17:G19,G14,G11,G7:G9	G7	=FALSE

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H6:H21	Expression	=$G6	text	NO

 

[trevolly]

Thanks for the info and I understand the theory but I just can’t work out what the conditional format formula would be for the cells.

 

[Toadstool]

Just use =$G6

 

[trevolly]

Thank u so much. I’m sorry I was being stupid, I was overthinking it all. Excel going round and round in my brain all day!