Actually, I meant to put UNIONS,INTERSECTIONS etc... (referring to the error
message Excel gives)...
BUT, since I didn't---Thanks for clarifying, Harlan

Regarding my proposed solution, thanks (again) for taking the time to
perfect it.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Harlan Grove" wrote:

First, don't change subject lines. Doing so screws up some newsreaders.

Ron Coderre wrote...
If you want to use a Conditional Format....
You'd need to put the formula in a cell and have the CF cell's Formula Is
refer to that cell.
....

You were using an intersection, not a union. So don't use either. Excel
treats colons, :, as operators for range references, returning
references to the smallest single area range containing all the range
references separated by the colons. For example, if you had a defined
name RNG referring to C5:J5, the expression RNG:H12 would result in a
reference to C5:J12. Conditional formatting has no problem with such
range references, so use

=AND(B1=MIN(E1:E5),ROWS(RNG:B1)=ROWS(RNG),
COLUMNS(RNG:B1)=COLUMNS(RNG))

Note that this also means Excel has no trouble with multiple cell
references that look like

Sheet1!A1:Sheet1!X99

as long as the worksheet name is the same.