I've got two spreadsheets called 'Scenario 1' and 'Scenario 2' (multiple
worksheets) which are identical except for different input parameters.

Each has an indentical worksheet called 'Summary' which pulls together key
stats.

Is there a way I can have a cell automatically shaded in Scenario2 if it is
different in value from Scenario 1?

TIA

Rob

Format menu - conditionally formatting.

Should require a bit of playing but you'll get there.

You might need a cell which compares the data and gives you a 1 if it's
the same or a 0 if it's not, then do conditional formatting on that, I
don't know. But you'll get there :)


--
gearoi
------------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=401923

Thanks but the problem, I think, is not how to apply conditional formatting
to the same cell as the condition - but a different one.

So, in your suggestion, I can easily create a cell that shows a 1 or a 0 (eg
cell B3) but how then do I apply the format to, say, B2, only if B3=1 ?



"gearoi" wrote in
message ...

Format menu - conditionally formatting.

Should require a bit of playing but you'll get there.

You might need a cell which compares the data and gives you a 1 if it's
the same or a 0 if it's not, then do conditional formatting on that, I
don't know. But you'll get there :)


--
gearoi
------------------------------------------------------------------------
gearoi's Profile:
http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=401923

Select B2,
Then, just change "Cell Value Is",
To "Formula Is",
And enter this formula:

=B3=1

Sorta simple ... no?

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RFJ" wrote in message
...
Thanks but the problem, I think, is not how to apply conditional
formatting
to the same cell as the condition - but a different one.

So, in your suggestion, I can easily create a cell that shows a 1 or a 0
(eg
cell B3) but how then do I apply the format to, say, B2, only if B3=1 ?



"gearoi" wrote in
message ...

Format menu - conditionally formatting.

Should require a bit of playing but you'll get there.

You might need a cell which compares the data and gives you a 1 if it's
the same or a 0 if it's not, then do conditional formatting on that, I
don't know. But you'll get there :)


--
gearoi
------------------------------------------------------------------------
gearoi's Profile:
http://www.excelforum.com/member.php...o&userid=26576
View this thread:
http://www.excelforum.com/showthread...hreadid=401923