conditional formatting - text contain

[lezawang]

Hi
I have column like the one below. I want to highlight all cells that contain Friday. So I went to CF-->highlight cells rules-->text that contains, then i typed Friday (or later typed friday) but nothing happened. What could be the issue? I highlighted the column before applying CF. Also the column generated from typing today day and then use autofill and then use custom formatting. Thank you


[TABLE="width: 145"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]Tuesday, 11-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Wednesday, 12-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Thursday, 13-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Friday, 14-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Saturday, 15-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Sunday, 16-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Monday, 17-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Tuesday, 18-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Wednesday, 19-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Thursday, 20-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Friday, 21-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Saturday, 22-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Sunday, 23-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Monday, 24-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Tuesday, 25-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Wednesday, 26-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Thursday, 27-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Friday, 28-09-18[/TD]
[/TR]
[TR]
[TD="align: right"]Saturday, 29-09-18[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

Are you sure the cells aren't simply dates formatted to show the name of the day?

 

[Peter_SSs]

Are you sure the cells aren't simply dates formatted to show the name of the day?

I think that is what the following is saying ..

.. the column generated from typing today day and then use autofill and then use custom formatting.

Try this CF (use a formula ..)

Excel Workbook
	A
1
2	Tuesday, 11-09-18
3	Wednesday, 12-09-18
4	Thursday, 13-09-18
5	Friday, 14-09-18
6	Saturday, 15-09-18
7	Sunday, 16-09-18
8	Monday, 17-09-18
9	Tuesday, 18-09-18
10	Wednesday, 19-09-18
11	Thursday, 20-09-18
12	Friday, 21-09-18
13	Saturday, 22-09-18
Cf Friday

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =WEEKDAY(A2)=6	Abc

 

[lezawang]

It is custom formatted cells. The formula is so beautiful. It worked so nice and I learned new thing using that formula.
Thank you all for the help.

 

[Peter_SSs]

It worked ...
Thank you all for the help.

You're welcome.