Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change format of cells (bold, italic) based on one cell's answer
I want to change the font of cells based on the answer on one cell - similar
to condition formatting, but now the format is based on what one cell reads e.g. if one cell has a value of 0, then the cells on that row should become bold, italics, BUT if the value is greater, then they remain constant. TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change format of cells (bold, italic) based on one cell's answer
You can still use conditional formatting:
Select B1 and in conditional formatting select Formula Is: =($A$1=0) and pick some format, say bold Then copy B1 and paste/special/format across the first row. If A1 is zero, then all the cells in the row should be bold. -- Gary's Student "Jabi" wrote: I want to change the font of cells based on the answer on one cell - similar to condition formatting, but now the format is based on what one cell reads e.g. if one cell has a value of 0, then the cells on that row should become bold, italics, BUT if the value is greater, then they remain constant. TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change format of cells (bold, italic) based on one cell's answer
hi,
that is conditional formating. assuming that the value you wish to read is in cell a2..... condition for all cells in row EXCEPT a2. if formula is =if(a20,0,1) this sets a true/false condition for a2 format = fontbold italic in the target cell coditions for cell a2 if cell value is less than or equal to 0 format = fontbold italic works on my pc regards FSt1 "Jabi" wrote: I want to change the font of cells based on the answer on one cell - similar to condition formatting, but now the format is based on what one cell reads e.g. if one cell has a value of 0, then the cells on that row should become bold, italics, BUT if the value is greater, then they remain constant. TIA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change format of cells (bold, italic) based on one cell's answ
Thank you! that has worked like a charm.
Kind regards "FSt1" wrote: hi, that is conditional formating. assuming that the value you wish to read is in cell a2..... condition for all cells in row EXCEPT a2. if formula is =if(a20,0,1) this sets a true/false condition for a2 format = fontbold italic in the target cell coditions for cell a2 if cell value is less than or equal to 0 format = fontbold italic works on my pc regards FSt1 "Jabi" wrote: I want to change the font of cells based on the answer on one cell - similar to condition formatting, but now the format is based on what one cell reads e.g. if one cell has a value of 0, then the cells on that row should become bold, italics, BUT if the value is greater, then they remain constant. TIA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
change format of cells (bold, italic) based on one cell's answ
Thanks alot! I have learnt something new.
Kind regards "Gary''s Student" wrote: You can still use conditional formatting: Select B1 and in conditional formatting select Formula Is: =($A$1=0) and pick some format, say bold Then copy B1 and paste/special/format across the first row. If A1 is zero, then all the cells in the row should be bold. -- Gary's Student "Jabi" wrote: I want to change the font of cells based on the answer on one cell - similar to condition formatting, but now the format is based on what one cell reads e.g. if one cell has a value of 0, then the cells on that row should become bold, italics, BUT if the value is greater, then they remain constant. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will my cells not format? | New Users to Excel | |||
Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) | |||
Change the Default Comment Format to NOT be bold | Excel Discussion (Misc queries) | |||
how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) |