Change the color of cells if the sum of those cells is equal to 12.

[dvd66har]

I need to enter a number in cells A1 through A20, if the sum of any of those cells is = to 12 then I want A1 through A20 fill color to be green. (1+9+2=12 or 12 in just one cell)
I have tried conditional formatting-New rule-Use a formula. The formula that I tried was =$A$1:$A$20=12 and format the cell green.

[Glenn Kennedy]

Nealrly there. Use =A1=12 for the formula and A1:A12 for the "applies to" range as in the attached sheet.

[dvd66har]

Thank you for the quick reply, when I click on the “Attached Files- Download” it takes me to a log on page where I log on and it keeps repeating the log on process.

[Glenn Kennedy]

This has happened to others before. Someone was complaining about htis a day or two back. I suggest you send me your email address by Private Message just reply tot he one I've already sent you) and I'll email it.

[zbor]

I've dowload it regulary

[dvd66har]

CF query to Email.xlsx
I got it downloaded and formatted some cells the way i need it to look.i am trying to attach it to this post, check attachment and thanks again.

[Glenn Kennedy]

We got this sorted by PM as the download wasn't working fo the OP. For the record, here's the final vesion:

[zbor]

Use:

=SUM($A$1:$A$20)=12