| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format Based on Formula in Cell
Hello,
I have a problem that I think should be easy to solve but I am clueless. I have a column of numbers. Some are hard coded and some are formulas. I would like to conditionally format this column based on whether or not the cell is a hard code or a formula. Is this easy to do? Any help would be greatly appreciated. Thank you Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Format Based on Formula in Cell
Copy/paste this UDF to general module in your workbook.
Function IsFormula(Cell) IsFormula = Cell.HasFormula End Function CFFormula is: =IsFormula(cellref) Gord Dibben MS Excel MVP On Thu, 3 Sep 2009 09:48:08 -0700 (PDT), cardan wrote: Hello, I have a problem that I think should be easy to solve but I am clueless. I have a column of numbers. Some are hard coded and some are formulas. I would like to conditionally format this column based on whether or not the cell is a hard code or a formula. Is this easy to do? Any help would be greatly appreciated. Thank you Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format based on a different cell | Excel Worksheet Functions | |||
| Conditional Format based on value of another cell | Excel Worksheet Functions | |||
| Conditional Format a row based on a cell? | Excel Worksheet Functions | |||
| Conditional Format based on other cell | Excel Discussion (Misc queries) | |||
| How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
Hybrid Mode
