Need Help on Conditional Formatting to highlight text

[HaramiPollins]

Hello Everyone, Good day!

I wanted to know if it would be possible to apply a colour rule for a column which is extracting data from another sheet in the same workbook?

Example: Sheet 2, I have entered this formula in cell A2="Book1"A2

Text copied is Pending
I would like to apply a rule to column A in sheet 2 if the text is Pending then it would highlight to Green.

I hope the above makes sense. Hoping someone could assist, Thank you.

Regards,
Harami

[leelnich]

Hi HaramiPollins- Select the cells you wish to highlight and apply Conditional Formatting as below:

Untitled.png

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[AliGW]

Create a conditional formatting rule and apply it to the whole of column A:

[Shareez Saleem]

In sheet 2, select the cell A2 to A15 (up to where you want), go to conditional formatting, Select "Use a formula to determine which cell to format"
Enter the formula, =$A2=""

[AliGW]

Shareez - I don't think this is what the OP has requested ...

[Shareez Saleem]

Ali, may be I have taken the question in other way. What I understood is, when the data is to be extracted (pending), the cells should highlight in Green.

It's good that you have given the right answer to OP.

[AliGW]

Ah, I see what you mean - I hadn't thought of it that way.

[HaramiPollins]

Brilliant, this is exactly what I was looking for @ AliGW.
Thank you AliGW for all the help and guidance, I really appreciate it.

@All, thank you for taking the time to help and assist. I do appreciate the help.

Regards,
Harami Pollins

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.