Two questions for cell color and sum

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.