Hello all,
I am using a deck of 20 cards as a results table.
I am generating the cards using a spreadsheet (OpenOffice Calc)
Right now I have different tabs for different parts of the
results table. For instance... (this is for a basketball game)
one tab is for scoring, one is for rebounding, etc...
4 tabs all together, with a 5 tab/sheet that pulls the info from the prev 4 to make
the results cards.
I'm trying to use conditional formatting to make a cells background
either green or red depending on info it pulls. I can do it cell by cell
but very time consuming and makes it where I would have to redo it all by hand if I make changes.
Bottom line I'm trying to make it where I take the # of the card (which is in upper left corner of card)
and using that in a formula to determine conditional formatting. Here is what I got.
$Scoring.$G$15=1
this works. It looks at my scoring tab and looks at G15 which is first result on that pages charts.
If it is a 1 i get a green background.
But for each of my 20 cards I would have to change the 15 to 16,17..35
i was trying this...
$Scoring.$G$(($Results3.$B$2)+14)=1
B2 is the number of the card.Which in this case is 1.
I get nothing.
Any ideas or comments on conditional formatting or an easier way to
accomplish what I am describing?
Thanks,
DN
