Input color and formula color
Instead of checking
If left(cell_.formular1c1,1) = "=" then
It would be better to use:
If cell_.hasformula then
Carlo wrote:
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
"Sunnyskies" wrote:
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
--
Dave Peterson
|