Spreadsheet Cell Color Conventions

1. Can you write a formula based on cell color?

Can you write a formula based on cell color?

Select the cells with the background color. Hit Alt + F8 and select the macro that we just added and click the Run button. Now, you will have a column of numbers that represents each color. Once you have these values for the numbers, you can then use them in any conditional function or formula.