In B2, Condition Faormatting

Value is:

=B2*1.04<=B1
Format Bold/Red

Assuming you want at least 4% less.

If you want this to work up and down a column, make sure there is no $
before the 4. If you go across a row, make sure no 4 before the B.

"Big_Tater" wrote:

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