Set the font as you want it to be, i.e. yellow background with red bold font
size 14, and then use Format | Conditional formatting to set the background
to white if the cell value is "".

Hope this helps.

Pete

"Teri" wrote in message
...
I want to change the format of a cell(s) so that whatever is entered (any
word[s], numbers, or combination) the cell changes from white background
(normal) to yellow background with red bold font size 14.
Can it be done?
Any suggestions please.