Anonymous

color function formula

6 votes

Sign in

(thinking…)

Sign in with:

facebook

google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →

Anonymous supported this idea · March 07, 2019

Anonymous commented · March 07, 2019

I think it would be great if there was a function returning the background color of a cell so the result could be used in other formulas (in a simple if or a countif)

But for now, if you want to count the number of non empty cells in a column with ONE background color, you can achieve this by using a table with a total row count [subtotal(103, column )] filtered by color.

Use F4 key to lock reference in a table

128 votes

Sign in

(thinking…)

Sign in with:

facebook

google

Forgot password?

Create a password

Signed in as (Sign out)

Close

We’ll send you updates on this idea

15 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded

Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

Best,
John [MS XL]

Anonymous supported this idea · March 07, 2019