Need formulas

[Sandy]

Hello!

I need a formula to find Max of Cell U6 in Sheets with tab
names "NYCA, NYCB, NYCC .... " through "NYCX"

I need another formula for: If the value in Cell M is red,
print "No" in cell N; otherwise, print "Yes" in cell N.

Any help will be greatly appreciated!

Sandy

 

[Biff]

Hi Sandy,

If the sheets are in sequence:

=MAX(NYCA:NYCX!U6)

The second question: You can't express a cell or font
color as a value to be tested for in a formula. What is
the value and why is it red? You should base the formula
on the answer to that question. You could use something
like:

=IF(M1>100,"NO","YES"

Biff

 

[Sandy]

Hi Gord!

Thanks for your reply.

Please see the note I emailed Biff. Any ideas will be
appreciated!

Sandy

-----Original Message-----
Sandy

Assuming the worksheets are adjacent.......

=MAX(NYCA:NYCX!U6)

1st guess.......

You cannot, by formula alone, check if a cell's color is red or font is red
unless you use a User Defined Function. Excel by default has no Function for
this.

How did the value get to be red? By Conditional Formatting? If so, look for
the same criterion that CF used.

2nd guess.........

If you mean the word "red" then......

=IF(M1="red","No","Yes") entered into N1

Gord Dibben Excel MVP XL2002

 

[Biff]

Hi Sandy,

I just did a test based on your data and it worked fine
for me. One possibiltiy is that you have formatted
cell 'U' as date and the target cells are mt? That could
produce a result that looks like 00-Jan-00.

Biff