| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with udf
Post the UDF code and describe how you are using it in connection with CF.
Gord Dibben MS Excel MVP On Fri, 26 Sep 2008 06:29:20 -0700, Bertus Swanepoel wrote: Hi, I have done this the UDF way, but now excel behaves strangely. I have applied the conditional formatting to cells in Sheet2. If I want to pick up a value from sheet 2 in sheet1 (formula in sheet 1 A1: ='Sheet2'!B6), nothing happend in sheet 1. Instead excel inputs a formula in a random cell in sheet 2 which refers to itself creating a circular reference. When I clear the conditional formatting from sheet 2 all is fine. Has anyone experienced this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a conditional format recognize a formula in a cell | Excel Discussion (Misc queries) | |||
| conditional format if the cell contains a formula | Excel Worksheet Functions | |||
| Conditional format if a cell has a formula or if a percent or numb | Excel Discussion (Misc queries) | |||
| Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
| How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
Threaded Mode
