Conditional Formatting Question

[M3rlin]

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
	A	B	C	D
1	Name	Potential Need	BackUp#1
2	Jim	Y	Sam
3
4		"Onanothertab"
5	0	1	0
Sheet1

 

[M3rlin]

I figured out how to properly copy the code for the HTML maker and thought it would be easier to read.

Book1
	A	B	C	D
1	Name	Potential Need	Back Up #1
2	Jim	Y	Sam
3
4		"On another tab"
5	0	1	0
6	1- if a5=0 green
7	2- if a5=1 red
8	3- if c5=1 and a5=1 yellow shading or c5=0, b5=1, c5=0 yellow shading
Sheet1

 

[Norie]

What cells/ranges do you actually wan to format?

 

[just_jon]

Should your 2nd condition be

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

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

 

[GorD]

ADVERTISEMENT

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]

In Reply to Norie:

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

 

[Von Pookie]

Continued here:
http://www.mrexcel.com/board2/viewtopic.php?t=177330