Question about excel cell formatting?

Asked By samuelaguila 10 points N/A Posted on - 10/09/2011

I've been trying to figure this out, I have three columns of data A,B and C. What I want to do is this, if the cell in column B and C contain data, I need to change the color of the text in the corresponding row in column A. (Green for B, Blue for C and Yellow for both)

how can I format this?
 

• Status: Open
• Question Views: 1156
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by joseph21

Go To Solution

Best Answer

Best Answer

Answered By joseph21 0 points N/A #90103

Question about excel cell formatting?

Hello,

First of all, select the data or group of cells you want to format, you can select the entire row, or even a single cell.

On the toolbar, Under "HOME" that's in case you're using office 2007 or 2010. Click on font button, represented by letter A as shown below in the picture

A color bar will pop-down and you will then;

Select a color of your choice and it will automatically fill the color in the selected area. 

In case you're using older versions of office, still, click on font tab in the toolbar and select to apply any color you wish.

Hope it works out for you.

About joseph21

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/09/2011
• Question Category: MS Excel

Answered By Sherin Viluel 0 points N/A #90105

Question about excel cell formatting?

 

You can do this by using few options in Microsoft Excel .I will take an example in order to explain this.

In the following table contains data in column A, B, C.

First apply the filter option to the entire excel sheet.

Select the entire work sheet and click on the filter option in data tab.

 

 

 

Now click on the filter button in the column B heading and click on the tick of the “select all” to untick all.

Then tick on the “blanks “tick box and click ok.

 

 

Now select the data in column A and click on the arrow of the font color option then select blue color and click ok.

 

 

 

Now make the filter to select all and filter blank cell in column C as above. And Make the font color of the data green.

 

 

 

Again make the filter select all and select all data in column B except Blanks as follows.

 

 

 

In the same way, select all in Column C except blanks.

Now select all the data in column A and change the font color to yellow.

Now remove the filer then you can have the font colors as you wish.

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel