Hi,

I was wondering if there was a way to find which cells have formula in them
and the high those that there is no formual. I have a spreadsheet that
sometimes we put hard coded number in a cell and other times there is a
calculation to get a number. I want to make sure hrad coded numbers get
highlighted while formula cells preserve their orignial formatting.

Thank you in advance,

Regards,

Nikki

You can press F5, click the SPECIAL button in the lower left-hand corner and
select the formula Option button for selection options. You can also check
the formula options you want off as well. The check boxes become available
after you click the Formula option button.

Kevin Backmann


"Nikki" wrote:

Hi,

I was wondering if there was a way to find which cells have formula in them
and the high those that there is no formual. I have a spreadsheet that
sometimes we put hard coded number in a cell and other times there is a
calculation to get a number. I want to make sure hrad coded numbers get
highlighted while formula cells preserve their orignial formatting.

Thank you in advance,

Regards,

Nikki

Thanks for your reply. I figured it out. there is a way to do conditional
formatting for all cells that contain formula and then distinguish them from
hard coded numbers.

http://j-walk.com/ss/excel/usertips/tip045.htm

Go to function would not work for me in this case beucae it is a large
spreadsheet and different people will work on it.

Thanks again,

Nikki

"Kevin B" wrote:

You can press F5, click the SPECIAL button in the lower left-hand corner and
select the formula Option button for selection options. You can also check
the formula options you want off as well. The check boxes become available
after you click the Formula option button.

Kevin Backmann


"Nikki" wrote:

Hi,

I was wondering if there was a way to find which cells have formula in them
and the high those that there is no formual. I have a spreadsheet that
sometimes we put hard coded number in a cell and other times there is a
calculation to get a number. I want to make sure hrad coded numbers get
highlighted while formula cells preserve their orignial formatting.

Thank you in advance,

Regards,

Nikki