# Conditional formating

#### Zyconoclast

##### New Member
Can I use different conditional formatting for different cells in the same spread sheet?
If yes, how can I do this. Thank you.

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### JoeMo

##### MrExcel MVP
Can I use different conditional formatting for different cells in the same spread sheet?
If yes, how can I do this. Thank you.

Yes. Confine each CF only to the cells you want it to apply to.

#### Cosmic Wizard

##### Board Regular
Can I use different conditional formatting for different cells in the same spread sheet?
If yes, how can I do this. Thank you.

In a word yes!!

Try this video Conditional formatting - highlight entire row based on a cell value

The below is from a thread call "Conditional Formatting Cells based on overlapping range": it could a good example of multiple criteria for conditional formatting.

Quote Originally Posted by BennyH View Post
Tried copying but still getting an error message for formula 1-amber? Maybe a picture describes it best, i want the cell formatting to come back with red if its> +/-10%, amber within 5% to 10% (over or under spent) & green if its within -5% to 5% of budget
:
Budget vs Actual Variance
<-10.1% -10% -5.1% -5% 0% 5% 5.1% 10% 10.1%>
Hi Benny, sorry about the late reply but actually had to do some work!! Shocking turn events.

I redid your project and got the results you needed!!

How I did it was with two formulas, but both using the same colors to achieve the results.

Five formulas were used, I will list them below, from smallest percentage to largest and then go through the steps I took

=\$D2<-10.1% Color Red

=AND(\$D2<=-5%,\$D2>=-10.1%) Color Yellow

=AND(\$D2>=-5%,\$D2<5%) Color Green

=AND(\$D2>=5%,\$D2<=10.1%) Color Yellow

=\$D2>10.1% Color Red

Steps taken to achieve results.

1) Highlight cells A2 too D6
2) Click on Conditional Formatting, Manage Rules
3) Click on New Rule
4) Click on Use a Formula
5) Paste formulas in to box
6) Click on the format box and choose your color
7) Click OK twice and there you have it

Make sure you remove the second \$ and you have the <=>signs in their correct place and that should do it!!

#### Zyconoclast

##### New Member
Thank you. I will try this and see if it works for me.

Replies
8
Views
873
Replies
3
Views
396
Replies
9
Views
455
Replies
4
Views
845
Replies
7
Views
226

1,196,015
Messages
6,012,861
Members
441,737
Latest member
bijayche

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