Forum Discussion
squirrel442
Feb 20, 2024Copper Contributor
Help with conditional formatting
Below is the screenshot of my spreadsheet:- I’m currently on the tab Oct23, this is the start data. Next tabs is Nov23, Dec23 and so on. What I’m wanting to do is add the new data to N...
squirrel442
Feb 20, 2024Copper Contributor
For some reason this doesn't work, tried in a number of different orders. Best I can get is every cell red. Even tried =XLOOKUP($A2, Oct23!$A:$A99, Oct23!B:B) (Adding $A:$A99 in each formula)
What's the B:B at the end?
Guess I'll have to stick with the first way. Might try find someone to send the sheet to and ask if they can set it up and send it back. Would that work??
What's the B:B at the end?
Guess I'll have to stick with the first way. Might try find someone to send the sheet to and ask if they can set it up and send it back. Would that work??
HansVogelaar
Feb 20, 2024MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- HansVogelaarFeb 20, 2024MVP
Sorry - my mistake. The formulas should have used Oct23!C:C instead of Oct23!B:B.
See the attached version.
- squirrel442Feb 20, 2024Copper Contributor1st_Try - is the 1st details you gave, this works (I think)
Xlookup - is what I'm struggling with, cannot seem to get that working.
https://drive.google.com/drive/folders/1v8loMjCktN7xcz4SQeFACL47WdBsCS9f?usp=sharing