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]

"Runner" <[email protected]> wrote in message
news:[email protected]...
> 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))