Setting of input cells as blue font and formula cells as black fon

S

Sunnyskies

Afternoon,

Can you please tell me how to set up a default format setting where if user
inputs data in a cell the font is blue and if a formula is created then it
remains a black font?

The key element of the question is default setting.

Thanks
 
A

AKphidelt

I'm not sure how to Conditionally Format this request without VBA. Someone
else might know though.

But if you highlight the Column(s) and press CTRL + G... and in that box
select the Formulas checkbox.... Then OK

This will highlight all the formulas and you can just change all their
colors at once. Using a macro you can do this whenever you want or if you are
familiar with VBA you can set it to a worksheet change event where it does it
automatically. I'd like to see if anybody else knows of a different way.
 
F

Florida User

Try this:
1. Define a rnage name Insert > Name > Define
Name the range CellHasFormula
Refers to =Get.Cell(48,Indirect("rc",False))
2. Select the cell you want to use conditional format and format blue
3 Same cell select conditional formating and enter
Formula is =CellHasFormula
Set format to black
 
Top