Re: Conditional Formatting Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <Domenic.1rwtqf_1120925104.4034@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Domenic.1rwtqf_1120925104.4034@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=10785
> View this thread: http://www.excelforum.com/showthread.php?threadid=385830
>


.

Quantcast