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}
- Could you revise the title of this discussion to help people who Search for existing solutions please (+ Thanks)? i.e. Color dates if more than 1 occurrence of some numbers in a column
- If you're not allowed to attach a file yet you can share it with i.e. https://support.microsoft.com/en-us/office/share-files-with-onedrive-4e871e9a-4cb7-4c66-8b38-d2ee590532c2, Google Drive or the like and post the shared link here
- I read your problem description several times and must admit I remain confused with a couple of things (i.e. why you refer to C9:C16 - that column appears to be empty in your pic.) so the following might not be what you expect (reflects what I understood):
In attached file and based on the above setup a Conditional Format. rule with the following formula applies to D7:L7:
=SUM(--(COUNTIF(D$9:D$16, Arr_DaysOff) > 1))where Arr_DaysOff is a defined name (in Name Manager) with:
={1,2,3,5}
Hope this helps & if this isn't what you expect please clarify/re-explain - Thanks
Attempted sending file in a direct message.