Help with Conditional Formatting

K

KenRamoska

Hi,
I have a spreadsheet.
Column A has a question.
The next 6 columns have the answer.
The next column has the right answer.
Is there a way I can do conditional formatting so that the right answer
is formatted with a gray background to show it is right. I like having the
answer
at the end but I was hoping not to have to manually gray each correct answer
box.
Thanks in advance. I know I might need an IF statement too or something.
 
B

Bob Phillips

Select cells B2:H100 (or whatever the rows are)

Goto Format>Conditional Formatting
Change Condition 1 To Formula Is
Add a formula of =B2=$I2
Click Format
Select the pattern tab
Choose the grey colour
OK

That does it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

Carim

Hi,

In cell B1, have conditional formatting Cell Value Is Equal to $H1
....
and then copy from column B to C:G ...

HTH
Cheers
Carim
 
K

KenRamoska

Hi Bob,
Thank you for your help. I still have a problem and it is my fault.
My answers are sentences.
A could equal.....Montana
B could equal......Maine......and so on.
So B2 = B2 won't work since Maine does not equal B but it is the correct
answer.
Is there still a way?
Ken
 
B

Bob Phillips

Can you explain that again? In what way is Montana a sentence, and who
suggested B2=B2?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
K

KenRamoska

Sorry, I will put more info...hope this helps.



Column A Column B Column C Column D
The best state? Maine Montana B

Here is a shortened version of my spreadsheet above.
Column A has the question. Column B and C have the answers.
Column D shows the right answer. I mistyped B2=B2
It is assumed Column B has the A choice
Column C has the B choices...and so on.

I don't think I can do this though....I have no way of getting Excel
to know that Montana equals choice B to get it to match to the B answer in
Column C.
 
B

Bob Phillips

Yes, just use the formula =B2=$D2 in the CF example I gave, selecting B2 and
C2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top