Conditional Formatting Question

Status
Not open for further replies.

M3rlin

New Member
Joined
Dec 23, 2004
Messages
39
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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0
What cells/ranges do you actually wan to format?
 
Upvote 0
Should your 2nd condition be

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

Otherwise, you're 1st part of the 3rd condition is in conflict.
 
Upvote 0
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
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,224,266
Messages
6,177,545
Members
452,783
Latest member
back1ply

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?

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
Back
Top