Conditional Formatting

[Steve]

A1 is Text or blank
A3:a10 is number or blank
If A1 = text A3:A10 is yellow
If A1 is Blank and A3>0
A4:a10 is grey
As A4:A10>0 the current cell has no format and remainder
of Range is still grey. It is also possible that A3:A6=0
A7>0 in which case A3:A6 has no format, A7 has no format,
and A8:A10 would be grey.

Thanks in advance!

 

[J.E. McGimpsey]

If I understand you correctly:

Select A3:A10:

Condition1: =ISTEXT(A1)
Format1: Yellow

Condition2: =ISBLANK($A$1)*(SUM(A10:$A$10)=0)
Color: Grey

Note: this will work only if A3:A10 are non-negative numbers