Live Traffic Feed

Thursday, August 18, 2016

How to fill the Color of a excel cell and changing the Color of text

If you want to fill the Color of excel cells for better readability and look then you might be using different Colors to differentiate the content in your excel.

For example, you can fill the headings of excel cell to a different Color.

To Fill the Excel cell with Color you need to use below option.



You may choose any Color with the list available or you can go to "More Colors" in the above screen shot and select "Standard Colors" given by default or "Custom Colors" as below.



In the above screen you can pick any Color by single click on Color and if you want to change the shade of the Color you can move the arrow Up and Down as required.

When you change the Color and Shade you may observe below RGB (Red, Green, Blue) values gets changed or else if you already know the RGB values you can enter those values directly in the fields so that it will automatically pick your known Color.

There is another Color model HSL (Hue, Saturation, Luminous) and based on HSL values Color will change accordingly.


You also have an option to remove the Color fill of the excel cell with the below option "No Fill"




Changing the Color of text in Excel

Default Color of the text we write in excel is black. If we wish to change the Color of the text there is an option below screenshot.

First Select the cell that you wish to change the Color and Choose the Color you want to change.




For instance if you wish to change the only part of the text in excel cell to red and other part of the text to green that is also possible.

For example,

"Hello World" below i want to change Hello in "Red" and World in "Green" then below is how we should do.

Double click on "Hello World" cell below and select only "Hello" with pressing mouse cursor and then select the Color "Red"



Similarly, Select the text only "World" and apply Color green.


Finally, it looks as below..








No comments: