I'm using this formula =COUNTIF(B3:AC3, "OT") >0 in conditional formatting to color all weekends blue when an employee has an OT date. All employees are required to have 1 weekend OT for the month. I want to make it a different color if a date is chosen so we can tell easier if they have no OT. The problem is, when I punch in OT on my test sheet the blue only shows up to the OT column and no further (see screenshot). What am I missing to make it show the entire row for the month?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I'm using this formula =COUNTIF(B3:AC3, "OT") >0 in conditional formatting to color all weekends blue when an employee has an OT date. All employees are required to have 1 weekend OT for the month. I want to make it a different color if a date is chosen so we can tell easier if they have no OT. The problem is, when I punch in OT on my test sheet the blue only shows up to the OT column and no further (see screenshot). What am I missing to make it show the entire row for the month?
Excel Facts
How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
