Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 398 Weeks Ago, 6 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 28 Aug 2017 My Price 5.00

Conditional Formatting

Conditional Formatting if cell contains the same text than another cell on another sheet

Hello everyone this is my first post, I hope it makes sense! I am a complete begginner with excel so bare with me,

Okay so I have a column Sheet1!C4:C28 that when I type text in such as "Testing1", I want it to check if it exists in Sheet2 and if it does, change the colour of that cell to green. I have a column in Sheet2 with text already in it that I want it to check, Sheet1!B2:B15.   Can anyone help please?

How do i set up conditional formatting to do:

IF (text from) Sheet1!C4:C28 equals (any text from) Sheet1!B2:B15 turn cell green

Thanks!!!

Answers

Maurice Tutor
(5)
Status NEW Posted 28 Aug 2017 11:08 AM My Price 5.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)