conditional formating help

[Mldeuser]

I have a worksheet that contains mostly vlookup formulas, our client would like to overwrite some of the formulas to see different outcomes. I would like to have a conditional formatting rule that would shade the cell if the cell does not contain a formula. This way we can easliy copy back the formula as necessary.

Thank you

 

[Jonmo1]

In my experience dealing with clients...
It is best to not let them see the formulas at all...
Except in a training environment so they can see how it works, verify it does what they want, and make requests for adjustments in the process.

But in normal day to day activities, they don't need to see the formulas.

I would suggest making a copy of the file, having copy/paste special values of all formulas.
Then the client can do whatever they like with the data, and your master file still has the formulas in tact.

 

[crook_101]

Hi,

Have to agree with jonmo re clients, formula & data.....my suggestion would be to get details of what variables they need, protecting cells/hiding formula and entering another column to allow variables to be inserted....or give them the values sheet

Easiest way to find formulas in live is F5>>SPecial>>tick Formula then fill whatever colour you like....

HTH
Ian

 

[Jonmo1]

But, you can use conditional formatting to highlight cells that don't have formulas..

Click Edit - Names - Define
Give it the name HasFormula
In the refers to box, put
=GET.CELL(48,INDIRECT("RC",FALSE))
Click Add
Click OK


Now you can use the conditional formatting formula
=HASFORMULA - this will color cells that DO have a formula

or

=NOT(HASFORMULA) - this will color cells that do NOT have a formula


Hope that helps.

 

[T. Valko]

I have a worksheet that contains mostly vlookup formulas, our client would like to overwrite some of the formulas to see different outcomes. I would like to have a conditional formatting rule that would shade the cell if the cell does not contain a formula. This way we can easliy copy back the formula as necessary.

Thank you

See this...

http://groups.google.com/group/micr...c/browse_thread/thread/6bf323d2cf859ecd?tvc=2