Conditional Formatting Question (Highlight cells which have Formula)

[ionelz]

Hi,
I want to highlight all cells which have Formula
I am using = isformula(a1)
It is working but on SPILL formula, where it highlight only initial cell formula, the spill, NO
How to fix this ?
Thanks

 

[etaf]

works for me in conditional formatting

Book3
	A
1	TRUE
2
3
4
5
6
7	TRUE
8
9
10
11
12
13
14	TRUE
Sheet1

Cell Formulas
Range	Formula
A1	A1	=ISFORMULA(A1)
A7	A7	=ISFORMULA(A1)
A14	A14	=ISFORMULA(A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A14	Expression	=ISFORMULA(A1)	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=ISFORMULA(A1)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[ionelz]

It doesn't for me
If at A1 I have a formula like FILTER(....)....which SPILL from A1 to A100
ISFORMULA(A1) highlight only A1, the spill, NO
And I apply the formatting to entire A column

 

[Fluff]

In the name manager create a new name ( I called it HasFormula) and in the refers to box put

=GET.CELL(41,INDIRECT("rc",FALSE))

then you can use

=LEFT(HasFormula)="="

in conditional formatting

For this to work it needs to be a macro enabled file & macros need to be enabled.

 

[ionelz]

In the name manager create a new name ( I called it HasFormula) and in the refers to box put

=GET.CELL(41,INDIRECT("rc",FALSE))

then you can use

=LEFT(HasFormula)="="

in conditional formatting

For this to work it needs to be a macro enabled file & macros need to be enabled.

Thank you so much !

 

[Fluff]

Glad we could help & thanks for the feedback.