Thread: How to use Excel functions

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?

"Runner" <Runner@discussions.microsoft.com> wrote in message
news:68530B6D-5D8E-4976-984A-8DBB75D4ABFF@microsoft.com...
> 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

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

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