conditional format based on sheet name

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi, I am using the formula below to put the sheet name in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
 
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA
 
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd



-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL ("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi, I am using the formula below to put the sheet name in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.
Click to expand...
.
Click to expand...
 
The following will take a date such as 7/15/04, transform
it to a text string of format "mmmm yyy", and highlight it
if it does not match the sheet name:

=TEXT(A1,"mmmm yyy")<>MID(CELL("filename",A1),FIND("]",CELL
("filename",A1)) +1,255)

If you evaluating col. A., select the col., then go to
Format > Cond. Formatting and use this formula.

Jason
-----Original Message-----
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd



-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL ("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi, I am using the formula below to put the sheet name in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Again, thanks for the help. I don't understand the
formula completely.

=TEXT(C10,"mmmm yyy")<>MID(CELL(filename,C10),FIND
("]",C10) +1,255)



-----Original Message-----
The following will take a date such as 7/15/04, transform
it to a text string of format "mmmm yyy", and highlight it
if it does not match the sheet name:

=TEXT(A1,"mmmm yyy")<>MID(CELL("filename",A1),FIND ("]",CELL
("filename",A1)) +1,255)

If you evaluating col. A., select the col., then go to
Format > Cond. Formatting and use this formula.

Jason
-----Original Message-----
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd



-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL ("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi, I am using the formula below to put the sheet name in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in
conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Didn't mean to send that last note. I have been working
on that formula, (thank you) and haven't got it working
yet. I am using

=TEXT(C10,"mmmm yyy")<>MID(CELL("filename",A1),FIND
("]",A1) +1,255)


The column the typed dates are in is C:C and cell B1 has
the formula which gives the sheet name. I pointed the
formula at one cell above. Figured I would start there
and one it works use the column.

Everything seems to work when I break it down section by
section but returns value when I put it all together.

Help???



-----Original Message-----
The following will take a date such as 7/15/04, transform
it to a text string of format "mmmm yyy", and highlight it
if it does not match the sheet name:

=TEXT(A1,"mmmm yyy")<>MID(CELL("filename",A1),FIND ("]",CELL
("filename",A1)) +1,255)

If you evaluating col. A., select the col., then go to
Format > Cond. Formatting and use this formula.

Jason
-----Original Message-----
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd



-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL ("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi, I am using the formula below to put the sheet name in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in
conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Send me your file, along with a brief descripiton of the
problem in the worksheet, and I'll take a look at it.

Jason
-----Original Message-----
Didn't mean to send that last note. I have been working
on that formula, (thank you) and haven't got it working
yet. I am using

=TEXT(C10,"mmmm yyy")<>MID(CELL("filename",A1),FIND
("]",A1) +1,255)


The column the typed dates are in is C:C and cell B1 has
the formula which gives the sheet name. I pointed the
formula at one cell above. Figured I would start there
and one it works use the column.

Everything seems to work when I break it down section by
section but returns value when I put it all together.

Help???



-----Original Message-----
The following will take a date such as 7/15/04, transform
it to a text string of format "mmmm yyy", and highlight it
if it does not match the sheet name:

=TEXT(A1,"mmmm yyy")<>MID(CELL("filename",A1),FIND ("]",CELL
("filename",A1)) +1,255)

If you evaluating col. A., select the col., then go to
Format > Cond. Formatting and use this formula.

Jason
-----Original Message-----
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd




-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL
("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi, I am using the formula below to put the sheet name
in
a cell on the same worksheet. Its from a worksheet that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in
conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Thank you!!!

=IF(C13<>"",TEXT(C13,"mmmm yyy")<>$B$1)

This is working. Thanks so much for the help.


Todd

-----Original Message-----
Send me your file, along with a brief descripiton of the
problem in the worksheet, and I'll take a look at it.

Jason
-----Original Message-----
Didn't mean to send that last note. I have been working
on that formula, (thank you) and haven't got it working
yet. I am using

=TEXT(C10,"mmmm yyy")<>MID(CELL("filename",A1),FIND
("]",A1) +1,255)


The column the typed dates are in is C:C and cell B1 has
the formula which gives the sheet name. I pointed the
formula at one cell above. Figured I would start there
and one it works use the column.

Everything seems to work when I break it down section by
section but returns value when I put it all together.

Help???



-----Original Message-----
The following will take a date such as 7/15/04, transform
it to a text string of format "mmmm yyy", and highlight it
if it does not match the sheet name:

=TEXT(A1,"mmmm yyy")<>MID(CELL("filename",A1),FIND ("]",CELL
("filename",A1)) +1,255)

If you evaluating col. A., select the col., then go to
Format > Cond. Formatting and use this formula.

Jason

-----Original Message-----
Wouldn't that detect only if that formula were not
entered? There is a date column where dates are typed in
(07/15/04). Thats the column I want to highlight if an
error is made. The day is the only thing that should
change.

I am wanting to use this worksheet as a template, thats
why I want to key the format off the sheet name. The
sheet name will change and the rest of the calculations
work automatically.

Thanks,


Todd




-----Original Message-----
Using "Formula Is" under CF:

=A1<>MID(CELL("filename",A1),FIND("]",CELL
("filename",A1))
+1,255)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi, I am using the formula below to put the sheet name
in
a cell on the same worksheet. Its from a worksheet
that
has pages for each month. So the result is a date and
year. I am looking for a formula I can use in
conditional
fomatting that would tell if a month and year that does
not match the sheet name is entered in a cell/column.

Can I do this?


=MID(CELL("filename",A1),FIND("]",CELL ("filename",A1))
+1,255)

Result: July 2004

TIA,

Todd
.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top