conditional formatting across sheets

  • Thread starter Thread starter athleticospizz
  • Start date Start date
A

athleticospizz

I am pretty sure you cannot do this:

Format the appearance (color, bold, etc.) of one cell,
based on the value of the same cell location - IN ANOTHER
SHEET. For example, make Sheet1, cell B2 - bold, if
Sheet2, cell B2 is zero.

Is there a workaround (conditional formatting won't let me
span sheets)?

THANKS!!!
 
Yes if you give the cell a name, insert>name>define and name it like OtherB2
then you can use formula is

=AND(ISNUMBER(OtherB2),OtherB2=0)

however if you plan to use this on multiple cells in might be a bit
impractical
naming all these cells
 
CF will span sheets if you use a defined range name.

Select Sheet2 B2. Assign a name to that cell using Insert>Name>Define

Then in Sheet1 B2 CF Formula is: =thename=0

Gord Dibben Excel MVP
 
Well, I have 60 columns and 300 rows on each sheet.

I want to format Sheet2 such that if there is a value
greater than zero in the matching cell on Sheet 1, than
the cell in Sheet2 is formatted.

Can I name the cells easily (for example, based on their
location, say G227)? And, once I do the conditional
formatting for a few cells in Sheet2, will auto-fill allow
me to do the others?

If you get a chance. Thanks!
 
Can I easily name all of the cells in a 60 column by 300
row data set? For example, have the names just become the
cell location - A1, A2, A3, B1, B2, B3...

I looked at insert name, but not sure if I can do it for
so many.

Thanks for any info - and previous!
 
Just a heads up, since you are referring to another sheet a blank cell will
trigger
=thename=0
 
Back
Top