Home

Excel Formula for Colored cells

%3CLINGO-SUB%20id%3D%22lingo-sub-752956%22%20slang%3D%22en-US%22%3EExcel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752956%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20see%20the%20attached%20screen%20shot%20is%20there%20a%20way%20to%20write%20a%20formula%20so%20that%20I%20can%20add%20up%20the%20colored%20cells%20per%20color%3Fcolumn%20F%20please%20advise%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-752956%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752979%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375658%22%20target%3D%22_blank%22%3E%40crazycaliguuy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerform%20any%20calculations%20based%20on%20color%20that's%20only%20with%20VBA%20programming%2C%20formulas%20work%20with%20values.%20But%20if%20you%20have%20some%20formal%20rules%20why%20this%20or%20that%20color%20is%20applied%2C%20such%20rules%20could%20be%20used%20for%20the%20calculations.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752982%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752982%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwell%20red%20equals%20dead%20jobs%26nbsp%3B%20green%20equals%20sold%20jobs%20and%20peach%20equals%20jobs%20bid%20pending%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752988%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375658%22%20target%3D%22_blank%22%3E%40crazycaliguuy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20but%20that%20says%20me%20nothing.%20What%20it%20will%20be%20in%20Excel%20terms%3F%20For%20example%2C%20if%20cell%20in%20column%20C%20is%20equal%20to%20%22Dead%22%20then%20red%2C%20if%20equal%20to%20%22Sold%22%20then%20green%2C%20etc%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752989%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752989%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwsell%20it%20would%20be%20as%20follows%20then%3C%2FP%3E%3CP%3Eif%20cell%20in%20column%20F%20is%20red%20then%20equakls%20dead%3C%2FP%3E%3CP%3Eif%20cell%20in%20column%20f%20is%20green%20it%20equals%20sold%3C%2FP%3E%3CP%3Eif%20cell%20in%20column%20f%20is%20peach%20then%20equals%20bid%20%2F%20pending%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753159%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20for%20Colored%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753159%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375658%22%20target%3D%22_blank%22%3E%40crazycaliguuy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20meant%20opposite%20-%20if%20cell%20value%20is%20...%20then%20...%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20one%20more%20column%20with%20the%20status%20which%20could%20be%20selected%20from%20drop-down%20menu%3A%20dead%2C%20sold%2C%20pending.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBase%20on%20values%20in%20this%20column%20you%20may%20color%20your%20table%20using%20conditional%20formatting%20and%20make%20some%20calculations%20taking%20status%20values%20as%20logical%20test.%3C%2FP%3E%3C%2FLINGO-BODY%3E
crazycaliguuy
New Contributor

Hello see the attached screen shot is there a way to write a formula so that I can add up the colored cells per color?column F please advise me. 

5 Replies

@crazycaliguuy 

Perform any calculations based on color that's only with VBA programming, formulas work with values. But if you have some formal rules why this or that color is applied, such rules could be used for the calculations.

@Sergei Baklan well red equals dead jobs  green equals sold jobs and peach equals jobs bid pending

@crazycaliguuy 

Sorry, but that says me nothing. What it will be in Excel terms? For example, if cell in column C is equal to "Dead" then red, if equal to "Sold" then green, etc 

@Sergei Baklan wsell it would be as follows then

if cell in column F is red then equakls dead

if cell in column f is green it equals sold

if cell in column f is peach then equals bid / pending

@crazycaliguuy 

 

I meant opposite - if cell value is ... then ...

You may add one more column with the status which could be selected from drop-down menu: dead, sold, pending.

 

Base on values in this column you may color your table using conditional formatting and make some calculations taking status values as logical test.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies