Conditional Formatting

R

RFJ

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
 
G

gearoi

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 :)
 
R

RFJ

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

Ragdyer

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

=B3=1

Sorta simple ... no?
 
Top