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}
This is close to what I am looking for. I would like for Row 7 to be highlight for any combination of numbers 1,2,3,5 in a column if their is more than one occurrence.
Using your work as an example I would like column 5 & 8 to highlight as well but not column 2 as it only has one occurrence. Hoping this clears up what I am looking for the file to do.
I am working on OneDrive so I can upload my file but having difficulties. Thanks.
Using your work as an example I would like column 5 & 8 to highlight as well but not column 2 as it only has one occurrence. Hoping this clears up what I am looking for the file to do.
I am working on OneDrive so I can upload my file but having difficulties. Thanks.
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}