Thread: Change background color with IF statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DarrenMPY DarrenMPY is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote