Shortest way to change to mannual feed font colour

[chintan_1985]

I have huge data in a sheet (almost 20 collumns and 245 raws) with and without formulas. I want to change the mannual feed cell font colour to Bule (or anything) from default (Black).


Please let me know the shortest way of doing that....


Thanks.

 

[Hui]

Chintan


What do you mean by "Manual Feed" ?

 

[srinidhi]

In Home Tab in Find & Select, click on Constants, this will highlight only the data where there is no formula. Now change the font color by clicking the font color in the home Tab.

 

[lohithsriram]

Use this VBA code on your Sheet object events. When you manually change any data (F2) on any cell, the cell forecolor turns blue. I hope this is what you are trying to achieve here.


Private Sub Worksheet_Change(ByVal Target As Range)

Target.Font.Color = ColorConstants.vbBlue

End Sub

 

[chintan_1985]

Thanks you all.


Manual Feed means "mannual input"