change color if text is = or not, to text in other column

  • Thread starter Thread starter KittyLover
  • Start date Start date
K

KittyLover

I am taking practice tests. ColB contains text (the correct answers). ColC
contains text (my practice answers). I want the cells in ColC to turn green
if my answer is correct (matches the text in ColB) and turn red if it is
incorrect (does not match the text in ColB).
I can't figure out how to get it to apply Conditional Formating on the
columns. It wants me to apply it to only a single cell. I've also tried
copying and pasting special just the formatting. It turns the cells in ColC
green if they match cell B2 (not the corresponding answer that is in the same
row).
Please help! Thank you!
 
Dear Kitty Lover,

Let say Col B2 has the correct answer and Col C2 is your practice answer.
First apply conditional formatting on C2 and press ok to out from
conditional formatting, then again go to C2 and delete the $ sign in range
area and press ok to quit from conditional formatting. Drag down to copy the
conditioanl formatting, hope it will work, I tried and its working.

Thanks & Regards

TFMR
 
Try this...

Assume you're answers are in the range C2:C10.

Select the entire range of cells C2:C10.
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=C2=B2
Click the Format button
Select the Fill tab
Select a shade of GREEN
OK>OK

Click New Rule

Use a formula to determine which cells to format
Enter this formula in the box below:
=AND(C2<>"",C2<>B2)
Click the Format button
Select the Fill tab
Select a shade of RED
OK out
 
You rock! This worked like a charm! Thank you!

T. Valko said:
Try this...

Assume you're answers are in the range C2:C10.

Select the entire range of cells C2:C10.
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=C2=B2
Click the Format button
Select the Fill tab
Select a shade of GREEN
OK>OK

Click New Rule

Use a formula to determine which cells to format
Enter this formula in the box below:
=AND(C2<>"",C2<>B2)
Click the Format button
Select the Fill tab
Select a shade of RED
OK out
Click to expand...
 
Thanks Hassan, but I didnt have a problem w/ applying conditional formatting
for the = to condition. I couldnt figure out how to get it to turn green if
it was equal to or red if it was not equal to. But the other poster (T.
Valko) solved the issue.
Thanks so much for trying to help me - I appreciate it!
 
Back
Top