Format a cell in a range of cells based on value of another cell

  • Thread starter Thread starter Barneypo
  • Start date Start date
B

Barneypo

In ExceI 2010, I want to highlight those cells in a range of cells
which are less than the value of another cell. I have tried several
formulas and nothing seems to work.

Example formulas applied to the range of cells in K5:K94:

=<$G$1

"=<$G$1"

="<$G$1"

=<"$G$1"

Any help would be appreciated,

Barney
 
Back
Top