Conditional Formatting

[Larry Anderson]

I have a spreadsheet where there are 9 cells (grouped together), I would like to use Conditional Formatting to change all 9 cells to YELLOW when all 9 cells added together equals 45.
Trying to figure out if I need to use Conditional Formatting - Highlight Cells Rules - Equal to - OR USE - Conditional Formatting - New Rule.

Would appreciate any help.

Thanks

Larry Anderson

 

[duggie33]

Hi Larry, you could try something like below...

Book1
	A	B	C
1	8	2	7
2	1	3	6
3	4	5	9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C3	Expression	=SUM($A$1:$C$3)=45	text	NO

I hope that helps,

Doug

 

[Larry Anderson]

Perfect. Just what I need.
Appreciate the help.

Thanks.

Larry

 

[duggie33]

Glad to help,

Doug