conditional format cell

[Teri]

I want to change the format of a cell(s) so that whatever is entered (any
word, 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.

 

[Pete_UK]

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]

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.

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

I want to change the format of a cell(s) so that whatever is entered (any
word, 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.

 

[Pete_UK]

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

Pete

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.

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

I want to change the format of a cell(s) so that whatever is entered (any
word, 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 -