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?
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?
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?
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.
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?
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
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.
