How do I write a conditional format to this situation?

If cell(s) in a column is formula, color brown.

Formula can be e.g =34567-12343 or =e27-6700

CONDITIONAL FORMATS usually test formula results or do a comparison of
two or more values. Just looking to see if a cell HAS a formula or not,
I'm not sure that's possible as a conditional format.

Are you sure you aren't wanting to format based on the formula results
in some way?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46839

Copy/paste this UDF to a general module in your workbook.

Function IsFormula(Cell)
IsFormula = Cell.HasFormula
End Function

In CFFormula is: =isformula(cellref)


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 16:49:01 -0800, Yossy
wrote:

How do I write a conditional format to this situation?

If cell(s) in a column is formula, color brown.

Formula can be e.g =34567-12343 or =e27-6700

Hi,

Create a name such as isFormula:
1. Choose Insert, Name, Define and enter isFormula in the Names in Workbook
box
2. Enter the following formula in the Refers to box
=GET.CELL(48,INDIRECT("rc",))
3. Highlight the range you want conditionally formatted and choose Format,
Conditional Formatting
4. Pick Formula is from the first drop down
5. Enter =isFormula in the second box
6. Click Format...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JBeaucaire" wrote:


CONDITIONAL FORMATS usually test formula results or do a comparison of
two or more values. Just looking to see if a cell HAS a formula or not,
I'm not sure that's possible as a conditional format.

Are you sure you aren't wanting to format based on the formula results
in some way?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46839

One way:

Select cell A1. Choose Insert/Name/Define and define a name, say,
"mycell" as:

Names in workbook: mycell
Refers to: =GET.CELL(6,!A1)


Select the cells to CF. Choose Format/Conditional Formatting, and set
the dropdowns and input box to read:

Formula is =LEFT(mycell, 1) = "="

and choose the desired format.










In article ,
Yossy wrote:

How do I write a conditional format to this situation?

If cell(s) in a column is formula, color brown.

Formula can be e.g =34567-12343 or =e27-6700