Input color and formula color

S

Sunnyskies

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
 
C

Carlo

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
 
D

Dave Peterson

Instead of checking

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

It would be better to use:

If cell_.hasformula then
 
D

Dave Peterson

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.
 
C

Carlo

Yeah, you're right!
Was a code-quickie.

Thx for the correction, always eager
to learn some new things.
 
G

Gord Dibben

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
 
Top