Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditonal Formatting : color the cell if it contains a formula
Hello,
I would like to inform the user whenever he is changing a cell which contains a formula by a value. The sheet is not protected and will not be. No macro. Usage of function inside the conditional formatting wizard. Thanks for helping me ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditonal Formatting : color the cell if it contains a formula
By no VBA, I assume you also mean no User Defined function written in VBA.
Given those specifications, I would guess your out of luck. -- Regards, Tom Ogilvy "Fr. Vandecan" wrote: Hello, I would like to inform the user whenever he is changing a cell which contains a formula by a value. The sheet is not protected and will not be. No macro. Usage of function inside the conditional formatting wizard. Thanks for helping me ! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditonal Formatting : color the cell if it contains a formula
Try this -
Select A1 Define a name, Ctrl-F3 name: getFormula refers to: =GET.CELL(6,A1) don't use $A$1 select a cell for your CF, Formula Is =LEFT(getFormula,1) = "=" Regards, Peter T "Fr. Vandecan" <Fr. wrote in message ... Hello, I would like to inform the user whenever he is changing a cell which contains a formula by a value. The sheet is not protected and will not be. No macro. Usage of function inside the conditional formatting wizard. Thanks for helping me ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting the Cell color directly in an IF formula | Excel Worksheet Functions | |||
conditonal formatting in VB | Excel Worksheet Functions | |||
Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
How do I do Conditonal Formatting with formula progression | Excel Worksheet Functions | |||
Formatting a cell for color that has a formula also | Excel Discussion (Misc queries) |