Conditional format formula need to change font colour

Hi all

I am trying to insert a conditional format formula so that if there is no entry in a particular cell in column D then the relevant row format is font red and bold.

i.e if D3 is empty or 0 then row 3:3 has the above format.

I have tried inserting this CF formula =D3=0 then applying the format but not working.

Please help.

Thanks

Si

Try:

=$D3=0

The $ makes the column D absolute (i.e. it freezes it) so that each cell in each row only looks at column D (within same row) only.

If you don't have the $ there, then it looks at a relative reference to the cell.