Conditional Formatting

[UFGATORS]

Need a little help, I have a spreadsheet where on line 2 are the dates of the month L2:AP2, I have the following formula for highlighting the weekend dates "=weekday(L2:AP2,2)>5" this works fine. However, I also want the cells below the weekend dates to be highlighted. I highlighted row 3 and entered the same formula as on line 2, it also worked but, when I tried to drag the formula down for the other rows all the cells highlighted. If I enter the formula for each line it works but I have 799 lines so this is not practical. Thanks in advance.

 

[Peter_SSs]

Try
=WEEKDAY(L$2:AP$2,2)>5

 

[UFGATORS]

Duh, why did I not catch this? Thanks Peter, I should have been able to figure this out.

 

[UFGATORS]

Peter, if permissible, piggy backing on the original question a friend created the following formula for copying entrees from on day to the next "=IF(OR(L802="",M802="",COUNTA(L3:L799)=0),"","→")" is it possible to alter the formula where it skips over the weekends to the next weekday? If I need to submit as a new thread I will,. Thanks again.

 

[Peter_SSs]

Thanks Peter, I should have been able to figure this out.

You're welcome.

Peter, if permissible, piggy backing on the original question a friend created the following formula for copying entrees from on day to the next "=IF(OR(L802="",M802="",COUNTA(L3:L799)=0),"","→")" is it possible to alter the formula where it skips over the weekends to the next weekday? If I need to submit as a new thread I will,. Thanks again.

I would need to see what the data is like (could be dummy data), how it is laid out, and the same for the expected results. Can you post a small screen shot (see my signature block below) and explain again in relation to that screen shot?