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

 

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

 

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.

 

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

 

Thnx guys