nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 220
- Office Version
- 365
- 2019
- Platform
- Windows
Gents,
I am dialing with a simple conditional formatting issue but I have not found a solution so far. Here is my problem;
Thanks for all help and comments in advance!
I am dialing with a simple conditional formatting issue but I have not found a solution so far. Here is my problem;
- I have two columns in my sheet namely; Group and No and every column has its own value (similar or different)
- I would like to highlight values if concatenate value of two columns is the same ( In one column, it is really easy)
- However, I do not want to do this job by creating a 3rd column which includes concatenate value of these two columns
IP2022_2ndbatch.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Group | No | ||
2 | A | 10 | ||
3 | A | 12 | ||
4 | A | 5 | ||
5 | B | 20 | ||
6 | B | 15 | ||
7 | B | 18 | ||
8 | A | 12 | ||
9 | B | 20 | ||
Sheet2 |
Thanks for all help and comments in advance!