Formula should not work

  • Thread starter Thread starter Biff
  • Start date Start date
B

Biff

Hi Folks!

Consider this formula:

=OR(A1=F1:J1)

Why does this formula work in conditional formatting? It
shouldn't. If you enter that formula in a cell on the ws,
you'll get #VALUE! because the reference is to a range
unless you enter it as an array.

CF will not accept array or union formulas. But the
formula as written above works in CF. Why?

Biff
 
Enter it as an array formula (Ctrl + Shift + Enter) and it will work

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
unless you enter it as an array.

Yes, I know that. But that doesn't explain why the formula
works in CF when CF will not accept array formulas.

???

Biff
 
All formulas, entered into CF, are treated as array formulas.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top