how do I change cell colour to show function used

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with functions created to be applied against figures in
appropriate cells. I would like the cells where the functions are used to
colour code to indicate which function was applied
 
If you want to color all cells having formulas, then:

Edit > Goto... > Special... > Formulas

this selects the cells. Then:
Format > Cells... > Patterns > and pick the color

If you want to color code specific functions, like =SUM(), you will need VBA.
 
Edit>Go to>Special, check Formulas
This will select all formulas so you can format them as required

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet with functions created to be applied against figures in
| appropriate cells. I would like the cells where the functions are used to
| colour code to indicate which function was applied
 
Back
Top