Forum Discussion
edelvizio
Aug 30, 2023Copper Contributor
Auto adjust cell color, if another set of cells has a specifc text
I want a cell to be colored according to the result of another Excel cell, is it possible? For example, a certain set of cells (say cells B1 to L1) turn red or green because the text of another cell ...
- Aug 30, 2023
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.
edelvizio
Aug 31, 2023Copper Contributor
Hi HansVogelaar,
Thank you very much for your answer. Unfortunately it did not work. I've tryied several times, but I do not know what I am doing wrong.
If you find out, please, let me know.
Regards,
Erick
HansVogelaar
Aug 31, 2023MVP
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?
- edelvizioSep 04, 2023Copper Contributor
HansVogelaar, thank you again for your answer.
You were totally right. Now I know exactly how to do this.
Regards,
Erick