| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format cell for $0 | Excel Worksheet Functions | |||
| Conditional Format Row when Value Changes in One Cell | Excel Worksheet Functions | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| conditional cell format | Excel Discussion (Misc queries) | |||
| Format of one cell conditional on another | Excel Worksheet Functions | |||
Hybrid Mode
