# Conditional Formatting or Conditiona statement

#### Latvian

##### New Member
Hello there..

I have this formula:

=IF(V10>(MIN(Y10,Z10,AA10)),"Not Good","Good")

Is there any chance that I can get the result of "Not Good" in red and the result of "Good" in green, in that particular cell? I tried the conditional formatting but it's not really working on this case.

Any help/ideas would be appreciated.

Thanks!

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Jonmo1

##### MrExcel MVP
Welcome to the board..

Conditional formatting should work for that...
Highlight the cell with that formula
format - conditional formatting
select "Value Is"
select "Equal to"
="Not Good"
Select Red Color
Select "Value Is"
Select "Equal to"
="Good"
Select Green Color
click OK

That should work.

#### Latvian

##### New Member
Thank you very much. This is great. It worked.

One more question, what about if you have a huge number of cells and it will be really tedious to do that for each cell manually, is there another way to select the colomn with the Good/Not Good thing and make it red/green automatically?

Thanks again!
Welcome to the board..

Conditional formatting should work for that...
Highlight the cell with that formula
format - conditional formatting
select "Value Is"
select "Equal to"
="Not Good"
Select Red Color
Select "Value Is"
Select "Equal to"
="Good"
Select Green Color
click OK

That should work.

#### Jonmo1

##### MrExcel MVP
Sure, follow the same steps as before, but just select ALL the cells you want it applied to first...then click format - condtional formatting - etc...

OR

After entering it in the first, copy that cell,
Then highlight the rest of the cells, right click - paste special - formats

#### Latvian

##### New Member
You saved my day!

Thanks a bunch.

Sure, follow the same steps as before, but just select ALL the cells you want it applied to first...then click format - condtional formatting - etc...

OR

After entering it in the first, copy that cell,
paste special - formats
onto the rest..

Replies
3
Views
81
Replies
4
Views
85
Replies
3
Views
702
Replies
42
Views
241
Replies
4
Views
142

1,191,499
Messages
5,986,917
Members
440,065
Latest member
JCH136

### 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.

### Which adblocker are you using?

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

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