Excel Formula for Colored cells

Question

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.&nbsp;

sergeibaklan · Answer

crazycaliguuy&nbsp;
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.

crazycaliguuy · Answer

SergeiBaklan&nbsp;well red equals dead jobs&nbsp; green equals sold jobs and peach equals jobs bid pending

sergeibaklan · Answer

crazycaliguuy&nbsp;
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&nbsp;

crazycaliguuy · Answer

SergeiBaklan&nbsp;wsell it would be as follows thenif cell in column F is red then equakls deadif cell in column f is green it equals soldif cell in column f is peach then equals bid / pending

sergeibaklan · Answer

crazycaliguuy&nbsp;
&nbsp;
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.
&nbsp;
Base on values in this column you may color your table using conditional formatting and make some calculations taking status values as logical test.

Forum Discussion

Excel Formula for Colored cells

5 Replies

Resources