Conditional IF statemet that prints if TRUE

T

tiffanymccarroll

New Member
Joined
Jul 18, 2016
Messages
3
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
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.
 
Upvote 0
Sure. Here you go. I don't think that worked very well. Can I send you file?
[TABLE="width: 1015"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD="align: left"]
clip_image002.png

<tbody>
[TD="align: center"]Hosting Calendar[/TD]

</tbody>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Revised[/TD]
[TD]July 18, 2016[/TD]
[/TR]
[TR]
[TD="align: center"]July, 2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]St. Rose Church[/TD]
[TD]St. Rose Church[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]St. Rose Church[/TD]
[TD]St. Rose Church[/TD]
[TD]Creekside Church[/TD]
[TD]Hillcrest Alliance[/TD]
[TD]Granite Springs Church[/TD]
[TD]Pioneer United Methodist[/TD]
[TD]Pioneer United Methodist[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]Mosaic[/TD]
[TD]St. Clare[/TD]
[TD]First United Methodist Loomis[/TD]
[TD]St. Augustine[/TD]
[TD]Auburn Grace Community[/TD]
[TD]First Congregational[/TD]
[TD]Elevation Church[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD="align: left"]

<tbody>
[TD="colspan: 2"][/TD]
[TD="align: left"]
clip_image005.png
[/TD]

[TD="align: left"]
clip_image006.png
[/TD]

</tbody>
23

<tbody>
</tbody>
[/TD]
[/TR]
[TR]
[TD]St. Johns[/TD]
[TD="align: left"]
clip_image008.png
Bridgeway

<tbody>
</tbody>
[/TD]
[TD]Lutheran Church of the Resurrection[/TD]
[TD]Cornerstone[/TD]
[TD]Shepherd of the Sierra[/TD]
[TD]Sierra Grace Fellowship[/TD]
[TD]Gracepoint Adventist Church[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]First United Methodist Roseville[/TD]
[TD="align: left"]
clip_image011.png
St. Augustine

<tbody>
</tbody>
[/TD]
[TD]First United Methodist Loomis[/TD]
[TD]Valley Springs Presbyterian[/TD]
[TD]SS Peter & Paul[/TD]
[TD]Auburn Presbyterian[/TD]
[TD]St. Teresa[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Centerpoint Community Church[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]
clip_image013.png

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

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
2K
AndyEd
A
L
  • Question Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
P
  • Question Question
VBA Code to Remove Blanks and Print the sheet?
Replies
8
Views
839
Pisky
P
W
  • Question Question
Conditional Formatting comparing of cells based on comparing value of one cell to a table
Replies
1
Views
926
wylothar
W

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top