L
LDanix
Is it possible to base conditional formatting on the contents of a cell
other than the one being formatted?
other than the one being formatted?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bobclark
use formula instead of cell contents.
i.e.
you want to format cell a1 based on b1
format|conditional formatting|formula is instead of cell value is
=b1>10
or
whatever you want it to achieve.
On Sat, 30 Oct 2004 08:37:05 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:
~>Is it possible to base conditional formatting on the contents of a cell
~>other than the one being formatted?
i.e.
you want to format cell a1 based on b1
format|conditional formatting|formula is instead of cell value is
=b1>10
or
whatever you want it to achieve.
On Sat, 30 Oct 2004 08:37:05 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:
~>Is it possible to base conditional formatting on the contents of a cell
~>other than the one being formatted?
B
bobclark
oh, I forgot to mention it has to be a value on the same sheet, easily overcome
by =othersheet cell on to the current sheet.
On Sat, 30 Oct 2004 08:37:05 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:
~>Is it possible to base conditional formatting on the contents of a cell
~>other than the one being formatted?
by =othersheet cell on to the current sheet.
On Sat, 30 Oct 2004 08:37:05 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:
~>Is it possible to base conditional formatting on the contents of a cell
~>other than the one being formatted?
G
Gord Dibben
Yes.
Select cell for CF.
Format>CF "formula is": =othercell="hoohah"
Gord Dibben Excel MVP
Select cell for CF.
Format>CF "formula is": =othercell="hoohah"
Gord Dibben Excel MVP
L
LDanix
I am attempting to base the formatting on another worksheet within the
workbook. But I keep receiving the error message "You may not use references
to other worksheets or workbooks for Conditional Formatting criteria." Is
there a way around this or am I out of luck?
workbook. But I keep receiving the error message "You may not use references
to other worksheets or workbooks for Conditional Formatting criteria." Is
there a way around this or am I out of luck?
D
David McRitchie
You quoted the exact answer to your question.
Stated another way create a helper cell or cells on the sheet that
reference the other sheet. Another posted suggestion was to create
a defined named.
Stated another way create a helper cell or cells on the sheet that
reference the other sheet. Another posted suggestion was to create
a defined named.
L
LDanix
That was so simple I can't believe I didn't think of it. One more question. I
have over 300 cells in 300 rows that I need to have CF dependant on the
unique value of a cell in each of the rows. Is it possible to copy CF the
same way a formula is copied from row to row causing the factors of the
formula to change respectively?
have over 300 cells in 300 rows that I need to have CF dependant on the
unique value of a cell in each of the rows. Is it possible to copy CF the
same way a formula is copied from row to row causing the factors of the
formula to change respectively?
David McRitchie said:You quoted the exact answer to your question.
Stated another way create a helper cell or cells on the sheet that
reference the other sheet. Another posted suggestion was to create
a defined named.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
LDanix said:I am attempting to base the formatting on another worksheet within the
workbook. But I keep receiving the error message "You may not use references
to other worksheets or workbooks for Conditional Formatting criteria." Is
there a way around this or am I out of luck?
D
David McRitchie
You can copy with the format painter (looks like a paint brush),
but it is a lot better to do all of your formatting at one time with
a selection. See
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
but it is a lot better to do all of your formatting at one time with
a selection. See
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
LDanix said:That was so simple I can't believe I didn't think of it. One more question. I
have over 300 cells in 300 rows that I need to have CF dependant on the
unique value of a cell in each of the rows. Is it possible to copy CF the
same way a formula is copied from row to row causing the factors of the
formula to change respectively?
David McRitchie said:You quoted the exact answer to your question.
Stated another way create a helper cell or cells on the sheet that
reference the other sheet. Another posted suggestion was to create
a defined named.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
LDanix said:I am attempting to base the formatting on another worksheet within the
workbook. But I keep receiving the error message "You may not use references
to other worksheets or workbooks for Conditional Formatting criteria." Is
there a way around this or am I out of luck?
:
oh, I forgot to mention it has to be a value on the same sheet, easily overcome
by =othersheet cell on to the current sheet.
On Sat, 30 Oct 2004 08:37:05 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:
~>Is it possible to base conditional formatting on the contents of a cell
~>other than the one being formatted?