conditional format cell
 

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.

conditional format cell
 

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.

conditional format cell
 

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.

conditional format cell
 

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 -