How to use Excel functions

[Runner]

Hi, can anyone tell me how to use the if function to highlight a cell in
green color if the value is greater 500 or less than 100 in a column?

 

[Andy Brown]

Hi, can anyone tell me how to use the if function to highlight a cell in
green color if the value is greater 500 or less than 100 in a column?

You can use IF as the basis of a Conditional Formatting formula ; see
http://www.contextures.com/xlCondFormat01.html

Rgds,
Andy

 

[Andy Brown]

You should end up with a Conditional Formatting formula akin to:

=AND($A1<>"",OR($A1<100,$A1>500))