conditional formatting revisited

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

athleticospizz

I should be clear on what I want to do. If any ideas,
please let me know.

Say Sheet1 has A1:C3 with A1=0, A2=0, A3=8, B1=0, B2=2,
B3=0, C1=0, C2=0, and C3=0.

Say Sheet2 has A1:C3 with A1=27, A2=11, A3=7, B1=34, B2=73,
B3=46, C1=53, C2=5, and C3=9

I want Sheet2 values: A3=7 and B2=73 to be BOLD, because
the corresponding values in Sheet1 are non-zero.

Is this possible?

Thanks Much!!!
 
One way:

Name Sheet1!A1:C3, say, "Table".

Then select Sheet2!A1:C3 (with A1 active) and enter this CF:

CF1: Formula Is =INDEX(Table,ROW(),COLUMN())<>0
Format: BOLD
 
Thank you for that. I am not quite getting the results
that I expect however. All the values in Sheet2 are bold.

I selected all the cells in Sheet1 and selected
Insert/Name/Define (and called it "Table"). I then used
the exact text in your formula (conditional formatting
applied to all cells in Sheet2).

I tried taking each of the "<" ">" signs out, but then
none were bold.

Am I getting the syntax right? Do I need to put a value in
the formula for ROW() and COLUMN()? I hope not (I have 60
columns and 300 rows!)...

If you get a chance - would appreciate a bit more detail...

:)

Oh, by the way when I say "0" for the cells in Sheet1, I
mean that they are empty. Perhaps this is the problem?

Thanks again!
 
Back
Top