Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for Changing a Formula
Hi,
I'd like a cell to change color when a user has entered a hard-coded number rather than the keeping the formula already in the cell. Any ideas? Thanks, Heather |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for Changing a Formula
See this:
http://groups.google.com/group/micro...cf859ecd?tvc=2 -- Biff Microsoft Excel MVP "HeatherT" wrote in message ... Hi, I'd like a cell to change color when a user has entered a hard-coded number rather than the keeping the formula already in the cell. Any ideas? Thanks, Heather |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for Changing a Formula
Hi,
You can use a VBA macro: Private Sub Worksheet_Change(ByVal Target As Range) Dim isect As Range Set isect = Application.Intersect(Target, Range("A1")) If Not isect Is Nothing Then If IsNumeric(Target) And Not Target.HasFormula And Target < "" Then Target.Interior.ColorIndex = 6 End If End If End Sub Since you are asking for a method to change the cell color when there is a hard coded NUMBER entered in the cell, not when the cell is cleared or when a text entry is made, then the above macro will do what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "HeatherT" wrote: Hi, I'd like a cell to change color when a user has entered a hard-coded number rather than the keeping the formula already in the cell. Any ideas? Thanks, Heather |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for Changing a Formula
Thanks to all ... all seemed similar to answer I found somewhere else and
ended up using. Created a general module in VBE for the workbook: Function IsFormula(Cell) IsFormula = Cell.HasFormula End Function Then used conditional formatting: CF-Formula Is-=NOT(IsFormula(CellRef)) Hope that helps for others as well! Heather "HeatherT" wrote: Hi, I'd like a cell to change color when a user has entered a hard-coded number rather than the keeping the formula already in the cell. Any ideas? Thanks, Heather |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting for changing data | Excel Discussion (Misc queries) | |||
Dynamically Copying Changing Conditional Formatting | New Users to Excel | |||
Conditional formatting: changing number format | Excel Worksheet Functions | |||
Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions |