Change background color with IF statement
 

I would like to make a formula that will highlight a specific range if
two statements are true. I have started with
=(IF(AND(A3100),(A72%)Range(A3:A10)... this portion gives no errors,
but I cannot find the command to turn the background color for this
range red. Any help??


--
DarrenMPY
------------------------------------------------------------------------
DarrenMPY's Profile: http://www.excelforum.com/member.php...o&userid=36787
View this thread: http://www.excelforum.com/showthread...hreadid=565003

Change background color with IF statement
 

Have you tried -Conditional Formatting- v. formulas?


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=565003

Change background color with IF statement
 

Can I use conditional formatting to format a range of cells? I know I
can do the entire row, but I want the background color to only extend
so far. Would I have to format each cell in the range individually with
the same argument?


--
DarrenMPY
------------------------------------------------------------------------
DarrenMPY's Profile: http://www.excelforum.com/member.php...o&userid=36787
View this thread: http://www.excelforum.com/showthread...hreadid=565003