khostomsky
New Member
- Joined
- Mar 19, 2022
- Messages
- 4
- Office Version
- 2021
- Platform
- Windows
Hello,
I need a (maybe not so) special conditional formatting. The situation is this.
In column "A" I have unique IDs (lets assume names), which can repeat in rows (this is important) but not necessarily. To each unique value belongs a value in a different column "B". I need to highlight a situation when to a specific unique ID in column "A" the SUM of the values in column "B" reach a certain value.
Example:
If to a certain ID the SUM of the values in column "B" reach "10" then should be highlighted the row (or cell).
I feel that it is probably not so complicated hence I am unable to formulate it in a working way.
Thank you!
Karel
I need a (maybe not so) special conditional formatting. The situation is this.
In column "A" I have unique IDs (lets assume names), which can repeat in rows (this is important) but not necessarily. To each unique value belongs a value in a different column "B". I need to highlight a situation when to a specific unique ID in column "A" the SUM of the values in column "B" reach a certain value.
Example:
If to a certain ID the SUM of the values in column "B" reach "10" then should be highlighted the row (or cell).
I feel that it is probably not so complicated hence I am unable to formulate it in a working way.
Thank you!
Karel