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

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.

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

Try,

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

Mike

"Barend SA" wrote:

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.

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

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

"Barend SA" wrote:

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.