Conditional formatting

[jishatomc]

I was doing conditional formatting to mark all Sundays in a month. As it has got duplicated i deleted all the rules which i applied. Then again i tried for using new formula, that time use a formula to determine which cell is to be formatted is missing. Kindly help me to recover it.

 

[scoudny]

Hi jishatomc

conditionally format with a formula, if your dates are in column A and drag down =WEEKDAY($A1)=1

 

[etaf]

=WEEKDAY(A2,1)=1

Book5
	A
1
2	Sun
3	Mon
4	Tue
5	Wed
6	Thu
7	Fri
8	Sat
9	Sun
10	Mon
11	Tue
12	Wed
13	Thu
14	Fri
15	Sat
16	Sun
17	Mon
18	Tue
19	Wed
20	Thu
21	Fri
22	Sat
23	Sun
24	Mon
25	Tue
26	Wed
27	Thu
28	Fri
29	Sat
30	Sun
31	Mon
32	Tue
33	Wed
34	Thu
35	Fri
36	Sat
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A36	Expression	=WEEKDAY(A2,1)=1	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=WEEKDAY(A2,1)=1

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[Joe4]

Welcome to the Board!

Are you saying that you need help creating the formula, or you cannot find the option to use a formula?
If the later, follow the steps shown here: Conditional formatting with formulas
You should see on step 3 that the formula option is the last one shown in the list of Rule Types.