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