Conditional IF statemet that prints if TRUE

[tiffanymccarroll]

I have calendars for the whole year created inn excel 2013. Each month a page. Different churches are scheduled each day during the year. I need a way to prit the calendar for each individual church that doesn't show others for privacy reasons.

For example: IF "First Baptist", BOLD, Highlight, if not, don't show or change font to white so it wont show

Any help would be greatly appreciated.

 

[CyrusTheVirus]

Hi Tiffany,

Could you please provide us with an example of your spreadsheet? copy/paste from excel into your reply.

Sounds like you might need a code for this, but maybe you could get by with some Conditional Formatting.

 

[tiffanymccarroll]

Sure. Here you go. I don't think that worked very well. Can I send you file?

Hosting Calendar <tbody> </tbody>
					Revised	July 18, 2016
July, 2016
Sun	Mon	Tue	Wed	Thu	Fri	Sat
					1	2
					St. Rose Church	St. Rose Church
3	4	5	6	7	8	9
St. Rose Church	St. Rose Church	Creekside Church	Hillcrest Alliance	Granite Springs Church	Pioneer United Methodist	Pioneer United Methodist
10	11	12	13	14	15	16
Mosaic	St. Clare	First United Methodist Loomis	St. Augustine	Auburn Grace Community	First Congregational	Elevation Church
17	18	19	20	21	22	<tbody> </tbody> 23 <tbody> </tbody>
St. Johns	Bridgeway <tbody> </tbody>	Lutheran Church of the Resurrection	Cornerstone	Shepherd of the Sierra	Sierra Grace Fellowship	Gracepoint Adventist Church
24	25	26	27	28	29	30
First United Methodist Roseville	St. Augustine <tbody> </tbody>	First United Methodist Loomis	Valley Springs Presbyterian	SS Peter & Paul	Auburn Presbyterian	St. Teresa
31
Centerpoint Community Church
<tbody> </tbody>
Hosting Calendar
					Revised	July 18, 2016
August, 2016
Sun	Mon	Tue	Wed	Thu	Fri	Sat
	1	2	3	4	5	6
	Granite Springs Church	Creekside Church	Hillcrest Alliance	SS Peter & Paul	Shepherd of the Sierra	First Baptist, Rocklin
7	8	9	10	11	12	13
Bethlehem Lutheran Church	St. Clare	Restoration	St. Augustine	Auburn Grace Community	Life Community Church	St. Teresa
14	15	16	17	18	19	20
Mosaic	Bridgeway	Lutheran Church of the Resurrection	Cornerstone	Hillside Church	First Congregational	Elevation Church
21	22	23	24	25	26	27
St. Johns	Valley Springs Presbyterian	First United Methodist Loomis	Gracepoint Adventist Church	SS Peter & Paul	Pioneer United Methodist	Pioneer United Methodist
28	29	30	31	Notes:
First United Methodist Roseville	Lifehouse	Sisters of Mercy	Community Covenant Church

<colgroup><col span="7"></colgroup><tbody>
</tbody>

 

[tiffanymccarroll]

Sorry. I got it now.
Here's a link: Imgur: The most awesome images on the Internet