Change background color with IF statement

  • Thread starter Thread starter DarrenMPY
  • Start date Start date
D

DarrenMPY

I would like to make a formula that will highlight a specific range if
two statements are true. I have started with
=(IF(AND(A3>100),(A7>2%)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??
 
Can I use conditional formatting to format a range of cells? I know
can do the entire row, but I want the background color to only exten
so far. Would I have to format each cell in the range individually wit
the same argument
 
Back
Top