Hello everyone.
I am hoping some one can help me with what is probably a fairly easy
problem that I can't seem to figure out.
I have a worksheet that I need to enter a function that will
automatically highlight cells based on a certain set of parameters. For
instance
Column A Column B
0 80
10 100
50 50
0 95
0 40
100 65
I want to highlight the row if Column B is less than 90 and Column A is
less than 5. If column B is less than 90 and Column A is over 5 the
cells should remain without fill. I think that this would be an IF
statement, but I am not that great with logical functions yet.
Any help to get me on the right track would be appreciated.
Thanks in advance!
--
jgp_2
------------------------------------------------------------------------
jgp_2's Profile:
http://www.excelforum.com/member.php...o&userid=27624
View this thread:
http://www.excelforum.com/showthread...hreadid=471436