changing cell color depending on value

[dr.L]

how can i say if A1 is more than 100 then make the cell color red.
and if A1 is less than 0 then make the cell color green.

Also can i make A1 turn red only if A2 is more than 100 AND A3 is between 80 and 100?

Help is much appreciated

 

[Joe4]

Take a look at Conditional Formatting in Excel's help files.

Post back if you run into any issues.

 

[dr.L]

Thank you for that, I have a little bit of trouble with the conditional formatting (using a formula to determine which cells to format.)
How would i write that i want to format A1 ONLY if A2 AND A3 are both true.

 

[Joe4]

Use AND, i.e.
=AND(A2=...,A3=...)