Is it possible to use font color or fill color in Excel as a cell reference?

For instance,

If I'm tracking vacation and sick days for personnel and I make the font color or fill color of a cell "blue" for 8 hours sick time, can I input a formula in another cell that can reference and total all the cells with blue font or fill color? So, if I had a row that had three blue 8's in it, is there a formula that can recognize that and give me the sum of 24?

3 Answers

  • 1 decade ago
    Favorite Answer

    No not with colour (color)

    Sadly Excel is formula / text based.

    You may consider - (advanced users) using lists and combo drop down boxes with the options of time of leave.

  • 1 decade ago

    Not dynamically, no. There are a number of things you can, depending on your level of Excel knowledge.

    The easiest recommendation I could make would be to make two rows (or columns, depending on the orientation of your sheet); one for "time worked", the other for "sick time" (note: you could go with even more columns to capture things like "vacation" or "jury duty")

    Then, just enter time in the appropriate column, and use the sum feature on the whole row or column.

  • 1 decade ago

    Yes the formula would be something like this:

    =sum(c9+c12+c18) or you can click on the E that looks like the greek alpha E in your tool bar at the top of the page then hold down the ctrl key and click on the individual cells that you want to add.

    good luck...

Still have questions? Get your answers by asking now.