• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HElP Vlookup with if and conditional formatting

L

Lmslms80

New Member
I have sheet A and B. I would like to see if some names from A are on B. If on B then highlight the name on Sheet A if date 1, date 2 or date 3 that are on sheet B are less than TODAY(). So if anyone of the dates are less than TODAY () then I want to highlight the name in sheet A. Please help. Thanks
 
Lmslms80
A and B are sheet names ... but ...
Sheets can have many columns.
Do You have any idea in which columns would find those names?
Same information would be good to get for those 'dates'.
Or
would You like to change all Your possible layout?
or
as many times, the sentence,
Upload a Sample File to get a quicker response
which You have read before Your message.
 
vletm said:
Lmslms80
A and B are sheet names ... but ...
Sheets can have many columns.
Do You have any idea in which columns would find those names?
Same information would be good to get for those 'dates'.
Or
would You like to change all Your possible layout?
or
as many times, the sentence,
Upload a Sample File to get a quicker response
which You have read before Your message.
Click to expand...


From the “A” tab I want to see if the name ABC Foundation is on the tab “B”. Then if it is I want to highlight the name ABC Foundation on tab “A.” However, I only want to highlight if the column due dates of C, E or G on the tab “B” are <= TODAY(). So if either date is <=TODAY() then I want to highlight the
 
@Lmslms80 - Okay Tabs can call Sheets.
... but column ... there are many many columns!
It would be much easier for You too to upload a sample file.
Then no need to guess what are You thinking?
 
From the “Test” tab I want to see if the name ABC Foundation is on the tab “Other Data”. Then if it is I want to highlight the name ABC Foundation on tab “Test.” However, I only want to highlight if the column due dates of C, E or G on the tab “Other Data” are <= TODAY(). So if either date is <=TODAY() then I want to highlight the name on sheet "Test"
 

Attachments

  • Main test.xlsx
    9.6 KB · Views: 4
You must log in or register to reply here.
Back
Top