sgexcel321
New Member
- Joined
- May 13, 2022
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
Hi, I wish to try to find out how can I color a cell if it contains a certain text.
I have found out how to count when it contains certain texts but I do not understand how to color a cell after much tries.
Below is a snippet of what I am currently doing.
So for example if I have two BRZ which contains either *ZC* or *ZD*, I wish to color the cell at A row 11/12 yellow or something. How do I really do it?.
Thanks, Best Regards
I have found out how to count when it contains certain texts but I do not understand how to color a cell after much tries.
Below is a snippet of what I am currently doing.
So for example if I have two BRZ which contains either *ZC* or *ZD*, I wish to color the cell at A row 11/12 yellow or something. How do I really do it?.
Thanks, Best Regards