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" wrote in message
...
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,$A1500))