Re: Excel Help
1) Go to Insert->Name->Define.
2) Type 'HasFormula' in the box at the top
3) In the 'Refers to:' box at the bottom type this exactly: =GET.CELL(48,INDIRECT("rc",FALSE))
4) Click OK
5) Highlight the area you'd like to conditionally format
6) Go to Format->Conditional Formatting
7) Select Formula Is from the dropdown
8) Type =HasFormula in the box to the right
9) Click the Format button and select your formatting
Voila! Pretty neat eh? Got that from mrexcel.com's message boards via google. Credit to Ian who posted it.
Link
|