highlight columns in conditional formatting

[bhatipuru]

I would like to highlight column B1:AF31 using conditional formatting.

If not conditional formatting- how to highlight column B1:AF31 based on weekdays. (I am currently working on Jan01 to Jan31).


Thank much.

 

[Andrew Poulsom]

You can use a conditional formatting formula:

=WEEKDAY(B1,2)<6

applied to the entire range when B1 is the active cell.

 

[bhatipuru]

You can use a conditional formatting formula:

=WEEKDAY(B1,2)<6

applied to the entire range when B1 is the active cell.

I have tried the conditional formatting but it is highlighting only ROW1 and I need it to highlight the column B1:AF31.

 

[Andrew Poulsom]

Select B1:AF31 and try the formula:

=WEEKDAY($B1,2)<6

which assumes that the dates are in column B.

 

[bhatipuru]

The date are in Row1

 

[Andrew Poulsom]

In that case:

=WEEKDAY(B$1,2)<6

 

[bhatipuru]

This works perfect. Thank you very much.