Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
I want to set conditional format so that it show when a cell contains a
formula and when a cell contains a value... This would be most valuable to use when user needs to input values.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
You need to create a UDF and use that
Function IsFormula(rng As Range) If rng.Count 1 Then IsFormula = CvErr(xlErrRef) Else IsFormula = rng.HasFormula End If End Function -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gerrit" <Gerrit @discussions.microsoft.com wrote in message ... I want to set conditional format so that it show when a cell contains a formula and when a cell contains a value... This would be most valuable to use when user needs to input values.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
Bob, not my initial query but thanks, spot on.
Steve "Bob Phillips" wrote: You need to create a UDF and use that Function IsFormula(rng As Range) If rng.Count 1 Then IsFormula = CvErr(xlErrRef) Else IsFormula = rng.HasFormula End If End Function -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gerrit" <Gerrit @discussions.microsoft.com wrote in message ... I want to set conditional format so that it show when a cell contains a formula and when a cell contains a value... This would be most valuable to use when user needs to input values.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
Great, maybe a 2-for-1 <vbg
Bob "Steve" wrote in message ... Bob, not my initial query but thanks, spot on. Steve "Bob Phillips" wrote: You need to create a UDF and use that Function IsFormula(rng As Range) If rng.Count 1 Then IsFormula = CvErr(xlErrRef) Else IsFormula = rng.HasFormula End If End Function -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gerrit" <Gerrit @discussions.microsoft.com wrote in message ... I want to set conditional format so that it show when a cell contains a formula and when a cell contains a value... This would be most valuable to use when user needs to input values.. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
I'm still a little confused as to how you then apply your UDF to a conditional format. The conditional format that I'm interested in applies only when a cell contains a formula; I'm not worried about whether it's a number or not. Do you still need a UDF since you only have one condition now? I'm new to conditional formatting, so thanks in advance for any help. -- mworth01 ------------------------------------------------------------------------ mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991 View this thread: http://www.excelforum.com/showthread...hreadid=512585 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
Yes you need the UDF as it is that that recognises a formula.
Add the UDF to your workbook. Select your cells, I'm assuming that you start at A1 In CF change Condition 1 To Formula Is Add =IsFormula(A1) Set your format OK -- HTH Bob Phillips (remove nothere from email address if mailing direct) "mworth01" wrote in message ... I'm still a little confused as to how you then apply your UDF to a conditional format. The conditional format that I'm interested in applies only when a cell contains a formula; I'm not worried about whether it's a number or not. Do you still need a UDF since you only have one condition now? I'm new to conditional formatting, so thanks in advance for any help. -- mworth01 ------------------------------------------------------------------------ mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991 View this thread: http://www.excelforum.com/showthread...hreadid=512585 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set conditional format to show when a sell contain a formula
Gerrit, oddly enough, i am trying to do the same today, just about to post
question wheni read yours. We have tried isref & isnumber but that doesnt work, have you had any luck yet? Steve "Gerrit" wrote: I want to set conditional format so that it show when a cell contains a formula and when a cell contains a value... This would be most valuable to use when user needs to input values.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |