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.
Quick Google search leans towards requiring a UDF/macro to do that…
Some useful pages from the search
Do these work in Google Spreadsheets?
Macros? Looks like it, but it’s not VBA (which kinda makes sense)
https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f maybe help you this link.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.