# color cell if condition met

#### irenesboy

##### Board Regular
This is the formula in cell G1.
I would like to add one more condition, if these conditions are met I would like to color the cell gray.
Can this be done?
I want to be able to copy it down the column.

=IF(OR(G1="aro",G1="aru",G1="ov",G1="und",G1="pao",G1="pau",G1="aco",G1="acu"),W1+X1,"")
irenesboy

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### pawebb

##### Board Regular
This is the formula in cell G1.
I would like to add one more condition, if these conditions are met I would like to color the cell gray.
Can this be done?
I want to be able to copy it down the column.

=IF(OR(G1="aro",G1="aru",G1="ov",G1="und",G1="pao",G1="pau",G1="aco",G1="acu"),W1+X1,"")
irenesboy

OOH OOH OOH!! I got it, I got it!

I use what you are looking for (I think). I used conditional formating to get the desired results.

Example: In cell A1 I have a formula that returns a number. If the number is 4.5 or greater it colors it green and if it is lower it colors it red.

To complete this select the cell(s) or range. Open the format menu and select Conditional Formatting...

You will get a pop up window.
1st drop down select "Cell Value Is"
2nd drop down select "greater than or equal to"
3rd entry I entered 4.5
Then click format and set your conditions if it is met so in my case I just selected green for the formatting.

Your second condition would be the results if it were below your desired results. So in my case if it is less than 4.5 color red.

It is really easy to use and once you have it open and play around with it a bit you will have it down.

Hope this helps.

Replies
5
Views
523
Replies
1
Views
149
Replies
2
Views
286
Replies
5
Views
420
Replies
2
Views
241

Threads
1,191,120
Messages
5,984,762
Members
439,909
Latest member
daigoku

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back