conditional formatting - text contain

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
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


Tuesday, 11-09-18
Wednesday, 12-09-18
Thursday, 13-09-18
Friday, 14-09-18
Saturday, 15-09-18
Sunday, 16-09-18
Monday, 17-09-18
Tuesday, 18-09-18
Wednesday, 19-09-18
Thursday, 20-09-18
Friday, 21-09-18
Saturday, 22-09-18
Sunday, 23-09-18
Monday, 24-09-18
Tuesday, 25-09-18
Wednesday, 26-09-18
Thursday, 27-09-18
Friday, 28-09-18
Saturday, 29-09-18

<colgroup><col></colgroup><tbody>
</tbody>
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Are you sure the cells aren't simply dates formatted to show the name of the day?
 
Upvote 0
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
2Tuesday, 11-09-18
3Wednesday, 12-09-18
4Thursday, 13-09-18
5Friday, 14-09-18
6Saturday, 15-09-18
7Sunday, 16-09-18
8Monday, 17-09-18
9Tuesday, 18-09-18
10Wednesday, 19-09-18
11Thursday, 20-09-18
12Friday, 21-09-18
13Saturday, 22-09-18
Cf Friday
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A21. / Formula is =WEEKDAY(A2)=6Abc
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top