# Conditional Formatting Question

Status
Not open for further replies.

#### M3rlin

##### New Member
I need help with the following conditional formatting question. I have listed 3 conditional formats that I need below. I have not used code, so if a formula can be applied that would be my first choice. Listed below are the 3 conditional formats I need:

1- if a5=0 green
2- if a5=1 red
3- if c5=1 and a5=1 yellow shading or c5=0, b5=1, c5=0 yellow shading
Book1
ABCD
1NamePotential NeedBackUp#1
2JimYSam
3
4"Onanothertab"
5010
Sheet1

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### M3rlin

##### New Member
I figured out how to properly copy the code for the HTML maker and thought it would be easier to read.
Book1
ABCD
1NamePotential NeedBack Up #1
2JimYSam
3
4"On another tab"
5010
61- if a5=0 green
72- if a5=1 red
83- if c5=1 and a5=1 yellow shading or c5=0, b5=1, c5=0 yellow shading
Sheet1

#### Norie

##### Well-known Member
What cells/ranges do you actually wan to format?

#### just_jon

##### Legend
Should your 2nd condition be

=AND(A5=1,C5<>1)

Otherwise, you're 1st part of the 3rd condition is in conflict.

#### GorD

##### Well-known Member
On your third condition, is that

if (c5=1 and a5=1) yellow shading

or (c5=0,AND b5=1,AND c5=0) apply yellow shading

or is it

if (c5=1 and a5=1_ yellow shading or

(c5=0 OR b5=1 OR c5=0) yellow shading

Hope thats makes sense

#### M3rlin

##### New Member
In Reply to Norie:

Cell A5 in the example and this is actually on another sheet tab.

Status
Not open for further replies.

Replies
42
Views
416
Replies
2
Views
286
Replies
1
Views
384
Replies
5
Views
312
Replies
5
Views
434

1,195,858
Messages
6,011,979
Members
441,661
Latest member
Pammie007

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

### Which adblocker are you using?

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