Conditional Formating

[arkadd61]

So If I would like to make a row change colors with conditional formatting based on where a value in a specific cell is <1 or >1 how would I write that out? I want to create 2 different rules. <1 Red >1 Green.

[FDibbins]

Assumine that the cell you are testing for ia in column A...

1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =$A1<1 format fill red

3. select new rule, select use formula
4. enter =$A1>1 format fill green

What color do you want 0 to be? if red, change to <= if green, change to >=

[Ddiehl3]

Dear Sir,
These conditional formatting functions are a pretty simple matter, BUT you have to be careful about monitoring both the area which is "functioning" and the wording of the function, as changes to the sheet (copying/pasting, etc...) can throw them awry.
1. Select Conditional Formatting, New Rule, Use formulas to blah blah blah...
The formatting functions themselves look like this: =IF($G1>1=TRUE,TRUE,"")
Which means: IF whatever you say is true in the particular cell (i.e. value greater than 1 is true), THEN the format you select becomes true, if false then nothing)
After you input your formula select format and select whatever you want to happen if your function is true.
Then go to manage rules and select which cells you would the function to function inside of. ($A$1:$G$5)

See attached for examples.
Hope this is clear...
Conditional Formating Formulas.xlsx

[FDibbins]

@ Ddiehl...using =IF($G1>1=TRUE,TRUE,"") is unnecessary. you can just use =$G1>1...if the result is TRUE, it will apply the format, while, if the result is not true - ie it is FALSE, the formatting will not be applied

[Ddiehl3]

Oh goodness, this will save time LOL