Conditional formatting to highlight day

[dasameer69]

Hi all,

i have day (Sunday, Monday, Tuesday) in C4, cell, now i want to highlight only the value of C4 for whole month..

thanks.routine.xlsx

[FDibbins]

Hi, welcome to the forum

Try this as your CF rule...
=WEEKDAY(H$2,2)=MATCH($C4,{"Monday","Tuesday","Wednesday","Thursday"},1)

(note, I did not add all the weekdays, I left them for you)

[dasameer69]

it's showing error.

[JeteMc]

I believe that for conditional formatting purposes the days of the week will need to be listed then referenced using a formula such as:

Please Login or Register  to view this content.

Note that this formula is referencing the days of the week that are listed in cells AN2:AN8 however the list could be moved to any location.
Let us know if you have any questions.

[FDibbins]

What error is it showing?
Can you upload your file again showing that error?

[Phuocam]

2 options:

1. =$C4=UPPER(TEXT(H$2,"dddd"))

2. =($C4=UPPER(TEXT(H$2,"dddd")))*LEN(H4)

[FDibbins]

I had not tested my suggestion IN CF, but only in actually cells, seeing as CF only needs T/F.

JetMc has pointed out to me - correctly, that you (I) cannot use an array in CF, so use this instead...
=TEXT(H$2,"dddd")=$C4

Essentially the same as post 6