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