How to highlight Excel cells with calculations?

[klm2klm2]

I'd like to be able to display Excel cells with calculations with different formatting than other cells. e.g. If the cell contents begin with the equal sign, let the displayed value be in blue instead of black. Is there a way to do this?

Thanks,
Kim

 

[SkipVought]

Only way I know...

1) paste this function into a MODULE in your workbook or in your Personal.xls

Function IsFormula(rng As Range) As Boolean
    
    If rng.Formula = CStr(rng.Value) Then
        IsFormula = False
    Else
        IsFormula = True
    End If
End Function

2) In COnditionalFormatting
[tt]
Formula is: =IsFormula(A1)
[/tt]
Substitute A1 for the the upper left-hand cell reference of the selection you are ConditionalFormatting.

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]

 

[GlennUK]

You can used a defined name ( say CellHasFormula ) that contains an Excel 4 command like this:
=GET.CELL(48,INDIRECT("rc",FALSE))

and use the defined name in conditional formatting, with the formula being
=CellHasFormula




Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[TonyJollans]

http://j-walk.com/ss/excel/usertips/tip045.htm

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[