How less value cell alert in an other cell

Q

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

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

Stephen

Qazi Ahmad said:
If cell A1 have Less then value 50, the Cell B2 Should become Red or any
cell
formate color(Cell B2 written "LESS VALUE")
Click to expand...

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