If you are asking how to put the text in B2 (and if you want the cell blank
if A1=50), then you need the formula =IF(A1<50,"LESS VALUE","")

If you are asking how to make B2 go red when A1<50, then in cell B2, Format/
Conditional Formatting/ Formula Is: =A1<50
Choose your red format.
--
David Biddulph

"Qazi Ahmad" wrote in message
...
If cell A1 have Less then value 50, the Cell B2 Should become Red or any
cell
formate color(Cell B2 written "LESS VALUE")