Forum Discussion
Solved
Color dates if more than 1 occurrence of some numbers in a column
I require help with this formula. I want Excel to highlight row 8 in red if cells C9 through C16 have more than one occurrence of numbers 1, 2, 3, or 5 input (refer to the color chart in the atta...
Missed/forgot something in my previous post (will delete it...) - Sorry:
Conditional Formatting rule that applies to $D$7:$L$7 with the above setup:
=SUM(COUNTIF(D$9:D$16,Arr_DaysOff)) > 1where Arr_DaysOff is a defined name (in Name Manager) with:
={1,2,3,5}
Here is an attempt with this adapted formula:
=SUM(COUNTIFS(C9:C16, {1, 2, 3, 5})) > 1
This formula counts the occurrences of numbers 1, 2, 3, or 5 in cells C9 through C16. If the total count of these numbers is greater than 1, it returns TRUE, indicating that the row should be highlighted.
Hope it helps.
- Thank you, I was not able to get this to work in conditional formatting.
Received the following:
You may not use reference operators (such as unions, intersections, and ranges), array constants, or the LAMBDA function for conditional formatting criteria.
