Formula should not work

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
 
A

Andy Wiggins

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"
 
B

Biff

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
 
A

Andy Wiggins

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LookUp (Date) Value from Forecast Data - From 2nd Sheet 3
I Need get work this formula 6
Excel not copying formula reference to original workbook 7
Comparing a value to a list of values does not work in Excel 2003. 3
Conditional Formatting using 3 Traffic Lights Formula 3
Using workday function to populate schedule 2
array formula does not work 5
Formula returning #N/A Error---why??? 4

Top