cell should fill with colour

[[email protected]]

if A1 is written with value "say"--50 -- and column "B1" is left blank than column"B1" should fill with dark red colour
anyone with formula pls help.

[zbor]

Use conditional formatting

=(B1="")*ISNUMBER(A1)

[[email protected]]

Pls explain stepwise

[akhileshgs]

Go to conditional formating>>Highlight cell rules>> More rules>> use formula

and enter that formula there

Simple