How less value cell alert in an other cell

[Qazi Ahmad]

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

 

[David Biddulph]

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.

 

[Stephen]

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.