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

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

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

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

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