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