Input color and formula color

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

Guest

Is it possible that on a spreadsheet, whenever you have cell with a formula
in it, the font color is black and if you have another cell where it is a
simple input field the cell font color is blue.

I do want to goto each cell and select black or blue. I do not want to use
conditional formating.

Is there not a format function or something that will allow this feature to
work on a spreadsheet.

Thanks
 
you could do it with VBA!

for each cell_ in activesheet.cells
if left(cell_.formular1c1,1) = "=" then
cell_.interior.colorindex = 1 '==> change to whatever you want
else
cell_.interior.colorindex = 2 '==> change to whatever you want
end if
next cell_

if you don't want to go through the whole sheet you can also
define a range. It's up to you.

hth

Cheers Carlo
 
Instead of checking

If left(cell_.formular1c1,1) = "=" then

It would be better to use:

If cell_.hasformula then
 
You could select the range (all the cells??)
Edit|Goto|special|check formulas
and click ok
And format them the way you want.

Then do the same thing for the constants.

This will be a manual effort and won't change colors if you add a formula or a
constant.
 
Yeah, you're right!
Was a code-quickie.

Thx for the correction, always eager
to learn some new things.
 
CF would be the best way to go to avoid the manual effort and would update when
formulas are added or removed.

What is your objection to CF?


Gord Dibben MS Excel MVP
 
Back
Top