Two questions for cell color and sum

Closed
Anker - Jul 26, 2016 at 05:21 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 26, 2016 at 07:03 AM
Hello,
Please need help. Using excel 2013
If in column E "personal" or "business" displays then in that same row the cell in column J must change to red or green.

Example
If E6= personal then J6=green
If E6=business then J6=red.

Then all the red boxes must be calculated together to display in L40
And all the green boxes sum displayed in N40.

Thank you for help. Really need it



Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 26, 2016 at 07:03 AM
Anker, Good morning.

Take a look at this little example I did for you:
http://speedy.sh/K7vP7/26-07-2016-en-Kioskea-Conditional-Format-OK.xlsx

Please tell us if it worked for you.
I hope it helps.
0