Formula to differentiate a cell with Formula and Number

[Subramanian2807]

Dear All,

Wishes for the day.

I have an excel sheet with several rows & columns with data and formula.

In certain cases, cell has formulas and some manual numbers added to it.

How do I identify such cells.

Thanks in advance.

 

[Somendra Misra]

Hi,

Go to Home tab, select Find & Select Tab, than select Formula or constant to higlight cells. Highlight them with some colour.

Regards,

 

[Subramanian2807]

Thanks for your reply.

But I want to highlight the cell which contains the formula and manually added number.

Kindly look into the attached sheet.

 

[Debraj]

Hi Subramanian!

* Select D2,
* Now press Ctrl + Space Bar. (Select complete Column, but activate range D2)
* Now you can simply select cells which are different than activated cell (D2) by pressing..
Alt + E + G + S + M (Goto > Special > Column Difference)

 

[Subramanian2807]

Thanks for your reply.

This is what I was aiming for.