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