Nested Conditional formatting....??

[zendog1960]

Hi everyone. It's been a while since I last posted here.

I have a range of B5:I10. I have used the =MOD(ROW(),2) to color every other row light grey. Just for Column I; If B5 isblank then the initial condition would be used, meaning every other row is grey. If $b5 has anything in it, then only I5 would be formatted to whatever color I manually put there without changing the rest of the range.

So maybe the question is this, If I have a range (B5:I10)that makes every other row grey, how can I override I5 If B5 has text without changing the other rows.

I hope this makes sense. I'm at work at the moment and need this help

Thank you in advance for all the help.

 

[zendog1960]

Maybe this might help. I want to have an end result like the example below.

Utility Tracking OR Critical Utilities.xlsx
	B	C	D	E	F	G	H	I
4	Type of Utility	Utility Owner	Size	Material	Approx. Length	Utility Location	Notes	Impact Level
5	Sanitary Sewer	City of Vancouver	10"	Cast Iron	1659'	Blah blah blah	these are blar blah
6	Sanitary Sewer	City of Vancouver	10"	Cast Iron	1659'	Blah blah blah	these are blar blah
7	Sanitary Sewer	City of Vancouver	10"	Cast Iron	1659'	Blah blah blah	these are blar blah
8	Sanitary Sewer	City of Vancouver	10"	Cast Iron	1659'	Blah blah blah	these are blar blah
9
10
11
12
13
14
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:H700	Expression	=MOD(ROW(),2)	text	NO

 

[etaf]

put a 2nd rule in for b5 - is it just the one cell ?
Now order so that
=MOD(ROW(),2)
Is the 2nd rule
and then if B5 <> "" then fill ,

Book9
	A	B	C	D	E	F	G	H	I	J	K
1
2
3
4
5		fred
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:K5	Expression	=$B5<>""	text	YES
A1:K20	Expression	=MOD(ROW(),2)	text	YES

 

[jtakw]

Hi,

Try this:

=AND($B5="",MOD(ROW(),2))