change format of cells (bold, italic) based on one cell's answer

J

Jabi

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
 
G

Gary''s Student

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.
 
F

FSt1

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(a2>0,0,1) this sets a true/false condition for a2
format = font>bold italic
in the target cell
coditions for cell a2
if cell value is
less than or equal to 0
format = font>bold italic

works on my pc
regards
FSt1
 
Top