I can't follow what you're doing with this very well but you can try to
combine the 2 conditions into 1 condition:

Instead of separate rules for:

'Cell Value' | 'less than' | 116
'Use a formula...' =MOD(ROW()-9,5)=0

Combine them into a single "Use a formula" rule:

=AND(relative_cell_reference<116,MOD(ROW()-9,5)=0)

Note that if the cell is empty it will evaluate to be <116. To account for
that:

=AND(relative_cell_reference<"",relative_cell_ref erence<116,MOD(ROW()-9,5)=0)

--
Biff
Microsoft Excel MVP


"aj scott" <aj wrote in message
...
Situation:
I have a 2007 spreadsheet of repeating groups of 5 distinct rows, ie,
numbers in any one of the five represent something different from each of
the
others tho' the values may be similar. Any one of the five rows may also
have
random cells with text.
I have four "cell value" rules that work as I want -- their ranges and
priority effectively allowing them to act across all rows without
conflict.
Problem:
Additionally I want to test for, & CF, Row 1 values < 116, but another row
has values that would be affected.
What I did:
--- New Rule 'Format only cells that contain' 'Cell Value' | 'less
than' | 116
--- specified the formatting
--- [Still in New Formatting Rule] 'Use a formula...'
=MOD(ROW()-9,5)=0
[there are 8 rows of intro above the data]
--- OKed my way out.
--- This is the last rule evaluated
What's right:
--- Only Row 1 values < 116 are thus formatted
What's wrong:
--- All text in Row 1 meets that criterion! Actually, I'm sure it's not
paying attention to the "< 116", only to the MOD.

I don't want text to be CFd. Can I "AND" in a test for "ISNUMBER"? I
can't
use ROW with it, because it's the cell level that has to be tested.
I tried preceding the problem rule with a rule to test for text, but it's
really bogus, =ISTEXT(CELL(0)), and doesn't work. Help, anyone?