To add to Domenic's reply, it's important that the active (white) cell of
the B2:B100 selection be B2 to use his formula. It probably would be, but
it's possible it not be. I thought it's worth a mention.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Domenic" wrote in
message ...

elew Wrote:
I am trying to use conditional formatting to highlight cells in a column
that are less than 150% of a value in another cell. Thanks

Assuming that B2:B100 contains your data, and that D2 contains the
value to be compare to, try the following...

1) Select B2:B100

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(B2<"")*(B2<$D$2*1.5)

4) Choose your formatting

5) Click Ok

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=385830