How to get "some specific dates" highlighted in excel columns with conditional formatting?

Hi there,
You can use formula to determine cells for conditional formating. My original dates are in column A.
For Sunday:

Formula:

Please Login or Register  to view this content.

Note that 'A1' is not fixed with $ sign. Maybe You have to change "Sunday" to You local language settings.

For holidays, You have to create holiday dates list. Mine is a named range called 'Holiday' and original dates are also in column A.

Formula:

Please Login or Register  to view this content.

Hope it helps

Hi there,

so on one side, You have dates in some columns and on second side You have special holidays dates somewhere in Your workbook.

For this case You can use formula for holidays mentioned in my 1st post.

If I misunderstood You again, pls upload Your sample workbook.

Miroslav, it may be that the OP didn't pick up on the use of a named range in your reply.

Anuru, see the conditioanl formating rule in this sheet.

Originally Posted by Glenn Kennedy

Miroslav, it may be that the OP didn't pick up on the use of a named range in your reply.

Anuru, see the conditioanl formating rule in this sheet.

Anuru,

I'm linking your related post here... How to get only "Sunday" highlighted in a series of dates in "cloumns"

Please find enclosed the extended version of Glenn's workbook taking care to both conditions (Sundays and Holidays) combined.

Considering list of dates are in column A and the list of holidays in column E, the formula used for conditional formatting is

Formula:

Please Login or Register  to view this content.

Note : Please avoid starting multiple threads for the same requirement in future.

Hopefully this is what you need. If so, please take the time to mark the thread as closed & consider saying "Thanks" by clicking the button to the left of the ADD REPUTATION symbol at the foot of their posts.

Glenn's solution works good and you have given different coding thru conditional formatting for Sundays and other holidays separately. My formula (in post #6) would also work good but will give you same color coding (not different colors for Sundays and other holidays). The formula needs to be changed as per your worksheet ranges as

Formula:

Please Login or Register  to view this content.

Note : Your worksheet design looks good for whatever you are trying to design as you have used a lot of colors and conditional formats. My advise to you is such a flashy design with colors / formatting cannot be easily reused in future. You (or someone else) would need to do a lot a rework along with the new functionality that needs to be incorporated. Also, debugging and tracking the error (in case) if some conditional formatting goes wrong (due to some changes in the worksheet ranges as and when you / others start tracking data in this worksheet) would be difficult. If in case users do some cut & paste or copy & paste the conditional formats would not work.