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}
Please attach a sample file so that we can work on that.
Harun24HR, I am unable to upload the file to the discussion. I am think this is due to me becoming a new member to the community from what I am seeing online. I am not certain when I would have that permission. I will see if I can come up with another solution to provide the file.
