Morning Chaps,
I'm having a small problem with Highlighting a row when a date is a Stat Holiday.
On the example in yellow are the two formulas that I have tried, both will only colour Column 'A' even though I have the full range set in the CF Rule.
Any ideas or pointing out what I am missing will be greatly appreciated.
Employee Schedule-Vertical.xlsx
Your formula should be:
Formula:
Please Login or Register to view this content.
I think you just got your $ backwards. It should be $D6, so that the date being checked is always in column D, and in the same row to be highlighted.
And a happy belated Canada Day!
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
like this look in row 10
Awesome: Worked a treat.Originally Posted by 6StringJazzer
Your formula should be:
Formula:Please Login or Register to view this content.
I think you just got your $ backwards. It should be $D6, so that the date being checked is always in column D, and in the same row to be highlighted.
And a happy belated Canada Day!
Happy Freedom Day Sir
Glad it helped!
We call it Independence Day, or more commonly just July Fourth.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks