Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerrit
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
mworth01
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
conditional formula to show "open" or "closed" SBS Excel Worksheet Functions 6 January 28th 06 01:48 AM
Conditional formatting...cont. from 9/25 Guenzak Excel Discussion (Misc queries) 4 September 26th 05 10:55 PM
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range Sam via OfficeKB.com Excel Discussion (Misc queries) 7 August 13th 05 04:19 AM
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 10:19 AM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"