Double_J

iTrader: (28)

How would I write the formula for this conditional format.

Lets say I want it to apply a condititional format to a different cell that meets the criteria?

Another words if the value in K1 is less than 1, apply a color to cell A1......

Thanks guys

Stevobob

iTrader: (1)

Use Conditional Formatting, it's in the format menu.

Craiger

iTrader: (1)

Once in conditional formating you have to write out the formula as the logic stage of an IF statement, so it will basicall look like this:

=K1<1

Then just select your formatting and when the statement is true it will apply the formatting.

HalifaxFD

iTrader: (18)

Sounds like there are a couple of excel nerds living near me. HAHAHA

Double_J

iTrader: (28)

Thnx guys