Color Coding Formulas

chrisguk

chrisguk

Board Regular
Joined
Jan 10, 2011
Messages
135
Hi,

I have a very big spreadsheet and I need to highlight those cells that formulas and not values. The reason I need this method is because I need to see their output value too.

Any ideas?

Im using excel 2007 by the way.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Press F5, click Special, tick Formulas and click OK.

All the cells with formulas will be selected then and you can colour them using the Fill Color button on the Home tab.
 
Upvote 0
VoG said:
Press F5, click Special, tick Formulas and click OK.

All the cells with formulas will be selected then and you can colour them using the Fill Color button on the Home tab.
Click to expand...


How long has it taken to know what you know?
 
Upvote 0
You must log in or register to reply here.

Similar threads

X
  • Question
Reverse nested lookup.
Replies
8
Views
125
xtrato
X
J
  • Question
Highlight in red all cells that have a formula with a mixed reference.
Replies
2
Views
75
Josecarlospdcj
J
J
  • Question
VB Macro for extracting Excel email address data to Outlook email draft
Replies
0
Views
193
Jaydee12
J
S
  • Question
Is there any other way to convert xlsb. to xlsx. file
Replies
2
Views
443
Sinh Le
S
L
  • Question
How to invert this formula
Replies
7
Views
165
LuGyver
L

Forum statistics

Threads
1,203,174
Messages
6,053,916
Members
444,694
Latest member
JacquiDaly

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top