About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How works Test new features Press Copyright Contact us Creators Unfortunately, there is no way to acceptably accomplish this task without using macros, in one form or another The closest nonmacro solution is to create a name that determines colors, in this manner Select cell A1 Click Insert Name Define Excel displays the Define Name dialog box Use a name such as "mycolor" (without the quote marks)Type a name in the Name field (Excel can display the name if you selected a data range with a heading line) The active or selected cell or range address appears in the box labeled Refers toVerify that the address listed is correct and then click OK to add the name to your spreadsheet and close the dialog box Note A faster way to create a name is to use the Name box (to the left
Why You Should Be Using Named Ranges In Excel