Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I conditionally format cells that contain formulas?
Is it possible to create a conditional format for a group of cells that would
set a specific backgroup color for cells that contain formulas as opposed to data? I have been using "Go To...","Special","Formulas" but would prefer to have the process happen automatically. TIF ... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I conditionally format cells that contain formulas?
Create a UDF and use that in the CF formula
Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jhofmann" wrote in message ... Is it possible to create a conditional format for a group of cells that would set a specific backgroup color for cells that contain formulas as opposed to data? I have been using "Go To...","Special","Formulas" but would prefer to have the process happen automatically. TIF ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I conditionally format cells that contain formulas?
First enter this tiny UDF:
Function IsFormula(r As Range) As Boolean IsFormula = r.HasFormula End Function Then set Conditional formatting: Formula is: =(IsFormula(A1)) -- Gary''s Student "jhofmann" wrote: Is it possible to create a conditional format for a group of cells that would set a specific backgroup color for cells that contain formulas as opposed to data? I have been using "Go To...","Special","Formulas" but would prefer to have the process happen automatically. TIF ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
converting general cells format to text | Excel Discussion (Misc queries) | |||
Format Cells - Date options | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |