Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default change color if text is = or not, to text in other column

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!
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default change color if text is = or not, to text in other column

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
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!



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 75
Default change color if text is = or not, to text in other column

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

"KittyLover" wrote:

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!

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default change color if text is = or not, to text in other column

2007

"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
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!




  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default change color if text is = or not, to text in other column

Try this...

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

Select the entire range of cells C2:C10.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse 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
OKOK

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

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
2007

"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
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!








  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default change color if text is = or not, to text in other column

You rock! This worked like a charm! Thank you!

"T. Valko" wrote:

Try this...

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

Select the entire range of cells C2:C10.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse 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
OKOK

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

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
2007

"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
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!






  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default change color if text is = or not, to text in other column

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!

"Hassan" wrote:

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

"KittyLover" wrote:

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!

  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default change color if text is = or not, to text in other column

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
You rock! This worked like a charm! Thank you!

"T. Valko" wrote:

Try this...

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

Select the entire range of cells C2:C10.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse 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
OKOK

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

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
2007

"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KittyLover" wrote in message
...
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!








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Text Function change output text color? epiekarc Excel Discussion (Misc queries) 1 December 31st 08 03:58 AM
Change text color CMM Excel Discussion (Misc queries) 1 September 11th 07 04:42 PM
Change text color Stanley Excel Discussion (Misc queries) 4 January 25th 06 03:52 PM
Change of text or background color doesn't change on the screen. Susan Excel Discussion (Misc queries) 5 July 29th 05 07:18 PM
Text Color Change Kim via OfficeKB.com Excel Worksheet Functions 3 March 11th 05 05:09 PM


All times are GMT +1. The time now is 12:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"