| 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! |
| 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 | |||
Threaded Mode
