Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
Change text color | Excel Discussion (Misc queries) | |||
Change text color | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Text Color Change | Excel Worksheet Functions |