Cell $M4=$S4="" stays empty
Also $M4=$T4>=5 fills red
These two formula work
When I apply the same formula to
Cells $N4=$W4="" fills red
$N4=$Y4>=5 fills red
What I am try to achieve is that when cells $S4 and $W4 are empty they are no format/no fill but when cells$M4 and $N4 contain a value they format to red if the content is >=5
Also $M4=$T4>=5 fills red
These two formula work
When I apply the same formula to
Cells $N4=$W4="" fills red
$N4=$Y4>=5 fills red
What I am try to achieve is that when cells $S4 and $W4 are empty they are no format/no fill but when cells$M4 and $N4 contain a value they format to red if the content is >=5