Alexwolfey
New Member
- Joined
- Oct 25, 2022
- Messages
- 3
- Office Version
- 365
- 2021
- Platform
- Windows
Hi….
I am have a table made and checkboxes added. I know how to change the color of a row with a checkbox, but I want it to only highlight SOME cells in the row, not all. I go to conditional formatting, press control and select the cells in the row I want to be highlighted with my checkbox but when I hit ok, I get this error message: “you may not use reference operations (such as unions, intersections, and ranges) array constants, or the lambda function for conditional formatting criteria”. I’ve done this before to make it only highlight certain cells on a row, but now I’m getting this error. Someone please help and tell me what I am doing wrong! I have attached images of my conditional formatting criteria and the error message.
I am have a table made and checkboxes added. I know how to change the color of a row with a checkbox, but I want it to only highlight SOME cells in the row, not all. I go to conditional formatting, press control and select the cells in the row I want to be highlighted with my checkbox but when I hit ok, I get this error message: “you may not use reference operations (such as unions, intersections, and ranges) array constants, or the lambda function for conditional formatting criteria”. I’ve done this before to make it only highlight certain cells on a row, but now I’m getting this error. Someone please help and tell me what I am doing wrong! I have attached images of my conditional formatting criteria and the error message.