Online PC Support

OPS Technical Solutions : +1 315-226-4066

Welcome

How to change Excel Cell Color using the ‘Conditional Formatting’

Follow the steps shown in this video and you will be able to change  Excel background color based on other cell value.

On The start Screen

  • Click on the Excel Sheet
  • Open the workbook where you want to make the changes
  • In current examples, we will set conditional formats
  • We have taken high value of 70 and low value of 55
  • Select the cells to be formatted .
  • In this example we are selecting the cells from B2 to B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to Greater Than to format the high values.
  • In the greater than window delete the value that appears and click on Cell F5 with the high values entered .
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value .
  • Clock Ok . Click Ok again to close the greater than dialog box .
  • You can see the cells greater than value 70 are colored green .
  • Now to color the cells low t value you can apply second conditional formatting rule to the cell .
  • Select the cells to be formatted .
  • In this examples we are selecting the cells from B2-B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to less Than to format the low values.
  • In the less than window delete the value that appears and click on Cell F6 with the low values entered
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value
  • Clock Ok . Click Ok again to close the less than dialog box
  • You can see the cells lesser than value 55 are colored red
  • In case you want to increase or decrease value you just need to change the value of high and low scorer. the changes would be done accordingly .

How to Make a FlowChart in Excel 2010

Looking for methods to create a flow chart in  Excel 2010, just follow the easy steps shown in this video.

Steps:

  • Open Excel
  • Click on insert tab  and go to the illustration group and then click Shapes .
  • Then select any shape on the flow chart section
  • Create the shape on the worksheet by clicking and dragging the mouse .
  • Insert more shapes from the insert group to complete the flow chart layout .
  • Select the desired shapes and align them by pressing the control key on your keyboard .
  • Now go to the arrange group , click align and choose the alignment option of your choice .
  • Repeat the same process to align the other shapes .
  • To add any text on the shape , select any shape and then right click on it and select add a text .
  • Type the required text in selected shape .
  • Repeat the process on other shapes .
  • Select the text box of any shape and then go to the home tab .
  • Choose thebasis text option from text box
  • Follow the same procedure for other text boxes of flow chart .
  • To add lines and arrows on the flow chart , go to the insert tab , click shapes and in the line section choose the preferred options .
  • You can create the shape by clicking and dragging the mouse.
  • Repeat the same process to create more lines in flow chart .
  • To edit the outline of the line or arrow select it and the shape styles group click shape out line.
  • Click on weight and then choose the line option , repeat the same option .
  • To change the style of the shapes of flow chart select the shape .
  • Open the shape style menu  and then choose the option of your choice .
  • Repeat the same process to change the style of other shapes in flowchart .
  • Done .

How to ROUNDUP a number in Excel

Do you want to round up a number, away from zero using ROUNDUP FUNCTION . Follow the steps shown in the video.

ROUNDUP function

Formula syntax and usage of the ROUNDUP function in Microsoft Excel.

Syntax : ROUNDUP(number, num_digits)

Number Any Real number required to rounded up.

Num_digits : Number of digits Required to round up.

If num_digits > 0, then number is rounded up to the specified decimal places.

If num_digits=0, then number is rounded up to the nearest integer.

If num_digits < 0, then number is rounded up to the left of the decimal point.

How to add Time in Microsoft® Excel

Watch this video to know about the steps How to add Time in Excel

Use the following custom number formats and the SUM function in Excel:

Hours = [h]:mm:ss
Minutes = [m]:ss
Seconds = [ss]

Create a worksheet and type the below given values. Make sure to use a colon (:) to separate the numbers.
A1: 12:36:58
A2: 12:25:30
A3: 11:19:23

Type the below mentioned formula into cell A4. Excel automatically formats the result correctly .

A4: =SUM(A1:A3)

Excel displays 36:21:51 as the total.

How to Make Your Blog More Appealing to Readers

Blog writing is an interesting way to reach out to people and earn money . But you have to make blog more attractive and the content should be interesting. If you are using blog to earn money then you know that the only way to earn more money is to keep the traffic coming. You will have to make the blog more appealing because once the reader read the blog, if he found it appealing, then he will return again. Networking is also very important if you want more traffic for the blog. Now we will discuss how to make the blog more appealing, follow the steps given below.

Step1: Design is very important, it is important to make blog attractive. You can put some animations and graphics but not overdo with loads of ads and annoying pop-ups. It is also very important to have clear and dark fonts so the readers find the blog easy to read.

Step2: If you want to get back the visited readers and search engine crawlers then always update the content. We recommend you to update the content thrice in a week. If you update contents at regular interval it will never become boring and lousy for readers.

Step3: Texts are the most important part of blog but if you add multimedia to the blog, it will become more attractive and interesting. A reader will stick to the multimedia for a long time and he keep coming back that will increase the traffic.

Step4: Networking is as important for a blog as the content. It is very important to inform people about the blog you are writing. Post the links and comments about the blog at different networking site to get attention from people. Also try to network with people who write same topic and do cross promotion. Cross promotion means that you will promote their blog and vice-versa.

Step5: Consistency is really important in term of writing. Suppose you are writing about some topic like poverty then try to concentrate on the topic. Do not try to merge so many thing in the blog, it will only deviate readers and make the blog boring.

Blog hosting sites are also very important, use the site that is friendly for bloggers and recommended by others. Otherwise you will have to face technical problems and that may alienate the readers. We recommend you to be humble when writing; readers show more interest in bloggers who shows more humility. Like you can show your weaknesses and tell them to write suggestions and comments. Make the blog more appealing by appreciating the comments on the blog i.e. try to tell the readers that comments are excellent, it will push them to write more and more. These are the tricks to make blog more appealing to the readers and increase the traffic.

Call Now: +1 315-226-4066
Call Now: +1 315-226-4066
Call Now: +1 315-226-4066