Hello Excel Community, I'm looking to have my Excel lookup a Column from a second worksheet, and Evalutate if there is anything within the range given. If so: Highlight the Cell red. Otherwise leave blank.
Eg.
Worksheet 1: Cell A1=John Smith, Cell B2=16:00 to 22:00
Worksheet 2: Cell A1=7:00 A2=8:00 etc. Cell B11=na, Cell B12=(blank)
What I want the first worksheet to do at this point: Highlight Cell B2 on Worksheet 1, Red. Then add a "Note" onto it with reason for highlighting. Simple: "(Cell A11 Name[In this case 16:00]) Value =na"
So I guess the question becomes, what kind of formula would that be using?
I'm also assuming that Cell B2 in the Example is valid. If invalid, would I have to shift to a 2 cell method, or is there another way of writing that same information in a way where the Excel spreadsheet recognizes it?
Eg.
Worksheet 1: Cell A1=John Smith, Cell B2=16:00 to 22:00
Worksheet 2: Cell A1=7:00 A2=8:00 etc. Cell B11=na, Cell B12=(blank)
What I want the first worksheet to do at this point: Highlight Cell B2 on Worksheet 1, Red. Then add a "Note" onto it with reason for highlighting. Simple: "(Cell A11 Name[In this case 16:00]) Value =na"
So I guess the question becomes, what kind of formula would that be using?
I'm also assuming that Cell B2 in the Example is valid. If invalid, would I have to shift to a 2 cell method, or is there another way of writing that same information in a way where the Excel spreadsheet recognizes it?
