How do I HIGHLIGHT a cell if it is smaller than a value X?

[Barend SA]

In a EXCEL spreadsheet I need to highlight cells (let them stand out) if the
value in the cell does not comply with a minimum laid down value. It must
ALERT met of the variance.

 

[Mike H]

Try,

Format|Cindirional formatting|cell value|is less than and enter your value
and choose a colour.

Mike

 

[Toppers]

Look at conditional formatting (FORMAT=>Conditional Formatting)

e.g for Data in Column B which must be >= 4


Select column B

in CF:


FormulaIs: =AND(B1<4,B1<>"")

Set pattern to required colour

HTH