Selecting and highlighting

I

intheway

Hi all -

What formula can I use in a column to compare a value in another cell
and if the value in the current cell is smaller than the cell i
compares to, then I want it to hightlight that cell- does not matte
what color. Not all cells will have data in the column, so I would onl
like to apply to those cells that have a value in them.

Thanks for your hel
 
N

Norman Harker

Hi intheway!

Lets use A1 as the cell with the base value and B1 as the cell that is
being compared to the base value.

Select the range of cells in column B
Format > Conditional formatting
Formula is drop down
Use the following formula
=AND(B1<$A$1,B1<>"")
Format tab
Select your formatting to taste
OK
OK

Note above that the base value cell is absolutely referenced but that
B1 is relatively referenced
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top