Format|conditional formatting:

Cell value is: Equal to: Wrong date

Excel will change that last string to: ="wrong date"



Oldjay wrote:

Thanks - Is there any way to conditionally format "Wrong Date" to red
"Dave Peterson" wrote:

=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date")



Oldjay wrote:

I have an input cell date that must be a Sunday
The next colunm over shows this date as a day of the week
I want the second cell to show "Wrong Date" if the date entered is not a
Sunday

--

Dave Peterson


--

Dave Peterson