Forum Discussion
Help with conditional formatting
Here is my first reply, modified:
Will the names in column A be the same each month, in the same order? If so:
Select C2:AQ99 on the Nov23 sheet.
C2 should be the active cell in the selection.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than or equal to' from the second drop down.
In the box next to it, enter the formula
=XLOOKUP($A2, Oct23!$A:$A, Oct23!B:B)
Click Format...
Activate the Fill tab.
Select red as fill color.
Click OK, then click OK again.
Repeat these steps, but with 'equal to', =XLOOKUP($A2, Oct23!$A:$A, Oct23!B:B)-1 and light red.
Repeat them again, with 'equal to', =XLOOKUP($A2, Oct23!$A:$A, Oct23!B:B)+1 and dark green.
Finally, with 'greater than or equal to', =XLOOKUP($A2, Oct23!$A:$A, Oct23!B:B)+2 and light green.
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??
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?
- 1st_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=sharingSorry - my mistake. The formulas should have used Oct23!C:C instead of Oct23!B:B.
See the attached version.