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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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

P
  • Question Question
Formula to locate and remove outlying values from a large data set
Replies
3
Views
195
hagia_sofia
hagia_sofia
W
  • Question Question
[Excel 365] Maximizing unique combinations of words - No repeats between any two words
Replies
4
Views
438
waffle
W
N
  • Solved
Totaling colored cells by their value
2
Replies
17
Views
527
nsipes
N
B
  • Question Question
Applying values to a database based on multiple criteria sets
Replies
1
Views
150
Baldred
B
M
  • Solved
Sheet code for conditional formatting
2 3
Replies
22
Views
527
MeaclH
M

Forum statistics

Threads
1,225,606
Messages
6,185,954
Members
453,333
Latest member
BioCoder84

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