Two questions for cell color and sum

Closed
Anker - Jul 26, 2016 at 05:21 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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



1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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