This is driving me nuts. :x It should be simple but I can't seem to get it to work or find the a thread with a working solution.
I have rows with dates in of the days of the week, ie B20 23Jul07 to F20 27Jul07 then row 21 with 30Jul07 to 03Aug07.
I want to conditionally format each row so that when the date in B2 TODAY() equals the date in the specific row the type becomes BOLD.
All I'm missing is the formula to get it to do that.
I've tried selecting the row, conditional formatting, Formula is =$B$2 and =TODAY().
Also tried IF with $B$2=B20:F20
I must have taken my stupid pills this morning.
Thanks in advance for your help.
I have rows with dates in of the days of the week, ie B20 23Jul07 to F20 27Jul07 then row 21 with 30Jul07 to 03Aug07.
I want to conditionally format each row so that when the date in B2 TODAY() equals the date in the specific row the type becomes BOLD.
All I'm missing is the formula to get it to do that.
I've tried selecting the row, conditional formatting, Formula is =$B$2 and =TODAY().
Also tried IF with $B$2=B20:F20
I must have taken my stupid pills this morning.
Thanks in advance for your help.