Color cell based on text/date content

[causej]

I am building a schedule and need the cell that results in "Monday" or the date of Mondays to Illuminate a particular color. Is there a logic statement or other function applicable?

 

[VoG]

Try Conditional Formatting http://www.contextures.com/xlCondFormat01.html

Excel Workbook
	A
1	20/05/2011
2	21/05/2011
3	22/05/2011
4	23/05/2011
5	24/05/2011
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =TEXT(A1,"dddd")="Monday"	Abc

 

[causej]

Can yo be specific as how to Conditionally format an entire row to shade based on formula resultants of "Mon,mmm,ddd"?

 

[VoG]

Like this?

Excel Workbook
	A	B	C	D	E	F	G	H
8	Mon,May
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A8	1. / Formula is =LEFT($A8,3)="Mon"	Abc

 

[causej]

Actually, I wanted only the cells within the row that resulted in "Mon,mmm,ddd" to shade. All other day/date results would remain unshaded.

 

[VoG]

Then you would remove the $

=LEFT(A8,3)="Mon"

 

[causej]

This is the formunal and the resultant for the schedule dates that are in the rrow begining A6.
=IF(TEXT(L6,"ddd")="Fri",L6+3,L6+1)
<TABLE style="WIDTH: 397pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=527 x:str><COLGROUP><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><TBODY><TR style="HEIGHT: 8.25pt" height=11><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; HEIGHT: 8.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=11 width=65 x:num="40693">Mon, May 30</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40694" x:fmla='=IF(TEXT(A1,"ddd")="Fri",A1+3,A1+1)'>Tue, May 31</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40695" x:fmla='=IF(TEXT(C1,"ddd")="Fri",C1+3,C1+1)'>Wed, Jun 01</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40696" x:fmla='=IF(TEXT(E1,"ddd")="Fri",E1+3,E1+1)'>Thu, Jun 02</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40697" x:fmla='=IF(TEXT(G1,"ddd")="Fri",G1+3,G1+1)'>Fri, Jun 03</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40700" x:fmla='=IF(TEXT(I1,"ddd")="Fri",I1+3,I1+1)'>Mon, Jun 06</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 9pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=12 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 49pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 width=65 x:num="40701" x:fmla='=IF(TEXT(K1,"ddd")="Fri",K1+3,K1+1)'>Tue, Jun 07</TD></TR></TBODY></TABLE>

I want the Monday's to be shaded, please.

 

[VoG]

Try like this. Select the range then apply the CF formula

Excel Workbook
	L	M	N	O	P	Q	R	S	T
6	Fri, May 20	Mon, May 23	Tue, May 24	Wed, May 25	Thu, May 26	Fri, May 27	Mon, May 30	Tue, May 31	Wed, Jun 01
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L6	1. / Formula is =TEXT(L6,"ddd")="Mon"	Abc