If cell=/ white then

[jcube]

Hi guys, beginner to excel here.

I am looking for a simple function which would give me back a value if the color of the cell where anything other than white.
And by simple I mean one that will work while using the spreadsheet online through gmail's drive system :P

So basically:
A1=white, unaltered
A2=blue, only background changed
A3=red, only background changed


I would then like to make a loop which would count the number of cells so something along the lines of
B1=if(A1=/white,1,0)+if(A2=/white,1,0)+if(A3=/white,1,0)

so B1 would give back 2 in this case. Searching the forum I only found some VBA solutions which I am not familiar with and dont know how to implement into the online spreadsheet. Hope I havent made it too complicated and that someone could help me or point me to a topic I could have missed.

Thanks in advance
Tom

[alansidman]

Here is a UDF to get the color code for a cell

Please Login or Register  to view this content.

Here is a UDF to get the color code for a font in a cell

Please Login or Register  to view this content.

You could then use a series of countifs to count the different color codes

[shg]

You're going to be hard pressed to do that without VBA, and unable to run VBA online.

[jcube]

Thanks for the replies. I will try to get more acquainted with UDF or I will just be forced to make everyone at work change the cells and not just color them :P

Thanks for the help

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.