Conditional Formating

Hi Everyone


Im having problems with the result I want with my formula.


The formula works but Im unable to copy to other cells


=IF(($I$4<>""),$I$4<0.5) Then highlight in yellow.


For example, for CELL "I5" I want the formula to show =IF(($I$5<>""),$I$5<0.5) without having to go in on every single cell and fix it.

When I merge conditional formatting, it copies exactly the same formula. Each formula should affect its own cell.

See attachment


Thanks in advance

Did you try $I4 instead of $I$4 ?

Could you please describe what your formula is supposed to check for?

PS "IF" is assumed in CF, so it's not necessary