101 Excel | How to have cells automatically formatted if they contain specific text?

Daily Office Tips by Office ToDo

#Tech #Daily #Tips #Office ToDo #Video #The Office #Word #Excellence #PowerPoint

36:16

DANMMMMM…Have I got a show for you! First, a lot of Sister Wives tea - new rumors have surfaced Janelle Brown is leaving the show. Plus, Gabe Brown gives a life update after losing and tragically finding his brother Garrison dead. Sadly, Garrison took his own life in March 2024. Then we head over to discuss the new Welcome To Plathville tea. The first pictures of Micah Plath have surfaced after being beat up by his brother Issac and it doesn’t look good for the future of his modeling career. Lastly, we discuss the latest in the Justin Baldoni v Blake Lively case, Justin is back on social media and it was the perfect social media return. Timestamps: 00:00:00 - Open and new Sister Wives news 00:05:43 - Janelle Brown leaving the show? Sister Wives Closet is officially closed 00:12:45 - A new pic of Micah Plath’s broken nose has surfaced 00:18:18 - Justin Baldoni back on social media and Taylor Swifts team is pissed at Justin Baldoni MY Go Big Podcasting Courses Are Here! Purchase Go Big Podcasting and learn to start, monetize, and grow your own podcast. USE CODE: MOM15 for 15% OFF (code expires May 11th, 2025) **SHOP my Amazon Marketplace - especially if you're looking to get geared-up to start your own Podcast!!!** https://www.amazon.com/shop/thesarahfrasershow Show is sponsored by: Download Cash App & sign up! Use our exclusive referral code TSFS in your profile, send $5 to a friend within 14 days, and you’ll get $10 dropped right into your account. Terms apply Horizonfibroids.com get rid of those nasty fibroids Gopurebeauty.com science backed skincare from head to toe, use code TSFS at checkout for 25% OFF your order Nutrafol.com use code TSFS for FREE shipping and $10 off your subscription Rula.com/tsfs to get started today. That’s R-U-L-A dot com slash tsfs for convenient therapy that’s covered by insurance. SkylightCal.com/tsfs for $30 OFF your 15 inch calendar Quince.com/tsfs for FREE shipping on your order and 365 day returns Warbyparker.com/tsfs make an appointment at one of their 270 store locations and head to the website to try on endless pairs of glasses virtually and buy your perfect pair Follow me on Instagram/Tiktok: @thesarahfrasershow ***Visit our Sub-Reddit: reddit.com/r/thesarahfrasershow for ALL things The Sarah Fraser Show!!!*** Advertise on The Sarah Fraser Show: thesarahfrasershow@gmail.com Got a juicy gossip TIP from your favorite TLC or Bravo show? Email: thesarahfrasershow@gmail.com Learn more about your ad choices. Visit megaphone.fm/adchoices…

14 years ago 0:39

MP4•Episode home

Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Text That Contains …” From the new menu type in the text which the cells containing are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. - Office ToDo

50 episodes

101 Excel | How to have cells automatically formatted if they contain specific text?

Daily Office Tips by Office ToDo

published 14 years ago

MP4•Episode home

50 episodes

#Tech #Daily #Tips #Office ToDo #Video #The Office #Word #Excellence #PowerPoint

All episodes

Daily Office Tips by Office ToDo

1
140 Excel | How to add, remove or reposition chart legend? 0:20

14 years ago0:20

0:20

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether you wish for the legend to show in the first place, or the placement of it if you decide to show it on the graph. - Office ToDo

Daily Office Tips by Office ToDo

1
139 Excel | How to add, remove or reposition text used to label each axis? 1:06:51

14 years ago1:06:51

1:06:51

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection. - Office ToDo…

Daily Office Tips by Office ToDo

1
138 Excel | How to add a title to the chart? 1:32

14 years ago1:32

1:32

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Chart Title” and from the appearing menu choose the placement of the title. Notice that you can also remove the title under this menu. - Office ToDo

Daily Office Tips by Office ToDo

1
137 Excel | How to compare pairs of values? 0:24

14 years ago0:24

0:24

Best used for this is the scatter chart. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Scatter” choose the type of scatter that suits you best. Unfortunately no live preview is available on this case. - Office ToDo…

Daily Office Tips by Office ToDo

1
136 Excel | How to emphasize differences between several sets of data over a period of time? 0:27

14 years ago0:27

0:27

Best used for this is area charts. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Area” choose the type of areas that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

1
135 Excel | How to compare multiple values on a chart? 16:54

14 years ago16:54

16:54

Best used for displaying multiple values comparison is a chart with bars. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Bar” choose the type of bars that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo…

Daily Office Tips by Office ToDo

1
134 Excel | How to display a contribution of each value to a total on a chart? 0:27

14 years ago0:27

0:27

Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Pie” choose the type of the pie chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo…

Daily Office Tips by Office ToDo

1
133 Excel | How to display trends over time on a chart? 0:25

14 years ago0:25

0:25

Best used for trends is a chart with lines. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Line” choose the type of the line chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo…

Daily Office Tips by Office ToDo

1
132 Excel | How to change the chart type? 0:26

14 years ago0:26

0:26

If you have for some reason chosen an inappropriate type of chart, you can easily change it. First select the chart and go under Chart Tools and Design tab. From there the very first button on the ribbon is called “Change Chart Type”. Click on it once and you’ll be able to try again with hopefully a more suitable chart type for you. - Office ToDo…

Daily Office Tips by Office ToDo

1
131 Excel | How to compare values across categories on a chart? 0:26

14 years ago0:26

0:26

Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Column” choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo…

Daily Office Tips by Office ToDo

1
130 Word | How to enable track changes? 0:11

14 years ago0:11

0:11

Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo

Daily Office Tips by Office ToDo

1
129 Word | How to delete a comment? 0:21

14 years ago0:21

0:21

Right click on the bubble and choose “Delete Comment” from the menu. In case you wish to delete all comments in your document, go under Review tab and under Comments section. From there choose “Delete” and “Delete all comments in document”. - Office ToDo

Daily Office Tips by Office ToDo

1
128 Word | How to insert a comment? 0:18

14 years ago0:18

0:18

Select your text or part of the text you wish to comment and go to Review tab. Under Comments choose “New Comment”. To the right side of the document a bubble appears. Into this you can leave your comments. - Office ToDo

Daily Office Tips by Office ToDo

1
127 Word | How to toggle through Word documents opened at the same time? 0:18

14 years ago0:18

0:18

One way, if you prefer not going to the taskbar, is to go under View tab and Window section. Click on “Switch Windows” and choose the document. - Office ToDo

Daily Office Tips by Office ToDo

1
126 Word | How to view different parts of my document at the same time? 0:23

14 years ago0:23