Hi Teri, thanks for feeding back. Glad you found two ways of doing it.

Pete

On Mar 3, 5:22*pm, Teri wrote:
Cheers Pete - tried your solution, also tried:
setting font size/colour and then using Format / Conditional Formatting
entered
FORMULA IS =COUNTIF(B53,"*")0
(B53 being my relevant cell)
Both worked.
:-)



"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -