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

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")

"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")

Select B2.
Format Conditional formatting.
Change "Cell Value Is" to "Formula Is" and put this formula in the box:
=($A$1<50)
Press "Format..." button and choose the format you want.
Click OK buttons to finish.