Find Formula Cell Quickly

[majidsiddique]

Hi All,
I need your help to find out only formula cell with highlight with color quickly. i have a large file with lot of small formula.

Thanks

 

[Michael M]

Try this

Sub MM1()
With ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, 23).Interior
    .ColorIndex = 3
End With
End Sub

 

[majidsiddique]

Hi Micheal,
Is it possible by formula?
Thanks

 

[Fazza]

maybe like post #6 in https://www.mrexcel.com/forum/excel-questions/588514-identify-cells-have-formulas.html

background info https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

 

[majidsiddique]

Hi Micheal,
Thanks for this,
its working.
Thanks

 

[majidsiddique]

Hi Fazza,
Thanks to you to provide me this information but desired result not possible. if yes please tell me
Thanks

 

[Fazza]

hello, Majid

I don't understand "desired result not possible".

I hope Michael's answer is sufficient.

If however you want to pursue the non-VBA formula please give further explanation.

regards, Fazza

 

[majidsiddique]

Hi Fazza,
i use this but only one formula cell highlight. kindly explain to apply whole sheet data. as above mention question discussed Micheal answer this quickly apply on formula cell. i use it but only one selected formula cell highlight. please tell me to apply whole sheet at once.
thanks.

 

[Fazza]

Maybe you applied the conditional format to only one cell? If so, change so that the conditional formatting is on the entire range. Such as if you select all the used cells on your worksheet & then the conditional format.

Is that OK?

 

[majidsiddique]

hi fazza,
yes, apply to whole sheet selected then highlight formula cell. please tell me step by step
thanks.