gpt-3.5-turbo-0613· OpenAI
WildChat-4.8M (AI2)
In the following ranges E2:I2, M2:Q2, U2:Y2, i have the days of the week represented as…
- User
In the following ranges E2:I2, M2:Q2, U2:Y2, i have the days of the week represented as three letter text i.e. Mon, Tues, Wed, Thu, Fri. How can I highlight the current day of the week in the respective cells
- Assistant
To highlight the current day of the week in the respective cells, you can follow these steps:
- Select the range E2:I2.
- Go to the "Home" tab and click on "Conditional Formatting" in the "Styles" group.
- In the drop-down menu, select "New Rule".
- In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
- In the "Format values where this formula is true" field, enter the following formula:
=TEXT(TODAY(),"ddd")=E2This formula compares the abbreviated day of the week (extracted from the current date using theTODAY()function) with each cell in the range E2:I2. - Click on the "Format" button.
- In the "Format Cells" dialog box, go to the "Fill" tab.
- Choose the background color or any other formatting style you want to use for highlighting the current day of the week.
- Click "OK" to close the "Format Cells" dialog box.
- Click "OK" again to close the "New Formatting Rule" dialog box.
Repeat the same steps for the other ranges M2:Q2 and U2:Y2 by selecting the corresponding cells and applying the same conditional formatting with the modified formula.