Forum Discussion
Auto adjust cell color, if another set of cells has a specifc text
Select B1:L1 (or more rows in columns B to L if you wish).
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$A1="text1"
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.Repeat these steps with the formula
=$A1="text2"
and red as fill color.
You should use $AL15 in the formula instead of $AL$16,
If it still doesn't 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?
HansVogelaar, thank you again for your answer.
You were totally right. Now I know exactly how to do this.
Regards,
Erick