A Formula to link 'TEXT' from cell in one sheet to another & highlight it present

hi, I'm new here. I'm looking for a formula in worksheet 'HOURS PAID' for column 'E' to pick up any date in the year from a database record in the first worksheet. I basically want column E of 'HOURS PAID' worksheet to pick up automatically if there is any text notes written in column 'G' of 'RECORDS' worksheet at all?

If there isn't any text I want cells in column 'E' to remain blank. And if there is text I want it to show in a specific middle pale yellow highlighted. Is this possible in 'conditional formatting' to format it to fill in colour to the cells 'if' there are text notes to record? I've re-attached the edited one with the formulas you stated to use, so you can see the conditional formatting & the fact it's changed the colour of the text not cell with text in.

How can I further down like this post attach the amended one directing to this post amended also, rather than edit the original post with it in please?

In E2:
=VLOOKUP(A2,RECORDS!A:G,7,FALSE)&""

and use this as the conditional formatting formula:
=LEN(E2)>0

CF/Manage rues/New rule/use formula.../then put the formula in the box and then format/fill.

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.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

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.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.