IT Support for New Brunswick Small and Mid-sized Businesses

NetAdmins provides enterprise-class IT services & tech support to New Brunswick, Nova Scotia and PEI small and mid-sized businesses. We manage every part of your IT, so you can focus on what you do best—running your business.

Partnering with NetAdmins is like having an entire IT support department at your disposal, whenever you need it. With a range of services including IP telephony (VoIP), email and web hosting, data back ups, paperless document management, security audits and 24-hour IT helpdesk, New Brunswick businesses can count on us as their only stop for business IT solutions.

On top of our à la carte offerings, we also provide comprehensive Managed IT Services in New Brunswick, Nova Scotia & PEI—including unlimited onsite and remote IT support, so you have a constant hedge against IT disasters. Our skilled computer technicians in New Brunswick maintain your business IT systems, keeping them in top shape, and minimizing downtime.

We make sure your managed IT services in New Brunswick are stronger and more secure so your users can be more productive and focused on your core business—always at a savings to your bottom line.

Contact us today to learn more about our Managed IT Service plans or our range of expert IT and communication services.

Excel’s conditional formatting is a popular feature that allows you to apply different formatting options, such as background color, shading, borders, or font formatting to data that meets certain conditions. However, you cannot change the font or the font size of the contents in the cell via conditional formatting. This must be done manually. Nevertheless, cells can be formatted to show up with a blue background or you can alternate cell row color to better illustrate your data. (See fig. 4 below.)

Let’s look at how to apply conditional formatting for shading. Select the cells to which you want to apply conditional formatting. Click Home > Conditional Formatting > New Rule.(see fig. 1) A New Formatting Rule dialog box will pop out. Select Use a formula to determine which cells to format item. Next, input the formula “=MOD(ROW(),2)” in Format values where this formula is true. Click Format. (see fig. 2)   Another Format Cells dialog box will pop out. Go to Fill tab and choose one color for shading the background. Click OK to return the New Formatting Rule dialog box, and also you will see the color in the Preview box. (see fig. 3)   and click OK to get the result you want. You can also insert or delete a row in the shading range and you will see that the shading color will follow. If you want to shade alternate columns, use this formula “=MOD(COLUMN(),2)” (see fig. 4)   

Figure 1

Excel Figure 1

Figure 2

Excel Figure 2

 

Figure 3

Excel Figure 3

Figure 4

Excel Figure 4

Comments are closed.