Can I use the background color of an Excel cell as a condition in a formula?


#1

As I say in the title, can I use the background color or the format of an Excel cell as a condition in a formula?

For example: I have a grid of numbers and names that I select by hand if I want the cell to be in a "red" format or "green" format. And I would like to have a counter of how many "green" and "red" cellsI have.

Is it possible? Can you think another way to achieve something similar?

Thank you very much.


#2

Quick Google search leans towards requiring a UDF/macro to do that...

Some useful pages from the search



#3

Do these work in Google Spreadsheets?


#4

Macros? Looks like it, but it's not VBA (which kinda makes sense)

https://developers.google.com/apps-script/quickstart/macros


#5

https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f maybe help you this link.


#6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.