| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting if a formula is replaced by value
On Apr 9, 9:18 am, mrbucc wrote:
I would like to set up a conditional formatting in case a cell is changed from a formula to a text value. I can protect the cells is an option but there are times when I will change the formula to a text but I would like to highlight yellow. Perhaps this User Defined Function could be used in the "Formula Is" part of the conditional formatting... Public Function NowText(Cell As Range) As Boolean NowText = Not Cell.HasFormula End Function Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula replaced with =#N/A in 2007 - why? | Excel Discussion (Misc queries) | |||
| Accidently replaced a spreadsheet that I did not want replaced | Excel Discussion (Misc queries) | |||
| %formula in conditional formatting | Excel Worksheet Functions | |||
| Conditional Formatting within a Formula | Excel Worksheet Functions | |||
| Can TRUE/FALSE be replaced by a formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
