About Us

Big_Tater[_2_]

Thanks again David!!

"David Biddulph" wrote:

If you copy that CF formula down (whether by selecting the range before you
type the CF formula in, or by copying and paste special/ formats, or by
using the format painter), that's how it will behave.
You could, of course, alternatively use Cell Value Is (instead of Formula
Is) / less than/ =B17*(1-4%)
and again it will change appropriately as you copy it down.
--
David Biddulph

"Big_Tater" wrote in message
...
Sorry about that.

Do you know if there is a way to copy this formula from B17:B382 so that
is
knows to run the formula based on the previous cell?

examples:
in cell B18 I want to have this formula =B18<B17*(1-4%)
in cell B19 I want to have this formula =B19<B18*(1-4%)
in cell B20 I want to have this formula =B20<B19*(1-4%)
etc.

Thank you for your help on this.
David

"David Biddulph" wrote:

CF/ Formula Is =B2<B1*(1-4%) or =B2<0.96*B1

Note that in one place you said less than 4% of yesterday's number, and
that
would be =B2<0.04*B1, but in another you say 4% less than B1, and that
would
be 0.96*B1. You need to be clear what you want.
--
David Biddulph

"Big_Tater" wrote in message
...
Can someone help me write a conditional formula based on a percentage.
I
want
to have my text turn red if today's numbers are less than 4% of
yesterday's
numbers. (I can do the conditional part, but I need help with the
formula.
Here is what I want in a formula.)

If B2 is 4% less than B1 make text Bold Red if its not less than 4% do
nothing.

Thanks.
David

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formating with len	doyree	Excel Discussion (Misc queries)	7	February 7th 08 11:20 PM
Conditional formating a row	bgl	Excel Worksheet Functions	1	August 10th 06 04:09 PM
Conditional Formating	Zee	Excel Discussion (Misc queries)	5	August 10th 06 02:56 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional Formating	Jeff	Excel Discussion (Misc queries)	2	October 5th 05 05:49 PM

Menu

About Us