Color-filled cell questions

[Guest]

I've copied Chip Pearson's VBA code for 'counting cells with a specific
color' into my spreadsheet - and it works - but:

1) If I protect the sheet, even though I leave the cells to be colored (fill
color tool) unprotected, I cannot fill/color the cells. They act like they
are protected, too. If I select Tools to format the cells, the cell
selection is grayed out.

2) How do I get the results of the formula to show after the cell is
colored? It eventually shows, but I would like it to show after tabbing from
the cell.

(Please note the first sentence - I know how to copy VBA, but as to
interpreting it - ???!!!)

TIA,

Carole O

 

[Dave Peterson]

It depends on the version of excel.

In xl2002+, you can protect the cell and allow the user to change formats.

In earlier versions, you have to do more work--either provide a macro that
allows background color changing (unprotect worksheet, color cells, reprotect
workbook).

And excel doesn't see a need to recalculate formulas when you just change
format.

But you can force a new calculation by hitting F9 whenever you need to.

So don't trust those results until you recalc.