Excel Sheet Doubt

[kunaltech]

Hello Experts,

I have 2 doubts in excel sheet.

1) i want to count no of colors i.e. how many rows/columns with blue color or red or white color.

2) i want to highlight particular column with some color if that value is set true/false

pls help me out with this

thanks in advance
Krunal Mehta

 

[maddy_in65]

To highlight particular column with some color if that value is set true/false, you can use conditional foramtting under foramt tab.

 

[kunaltech]

thanks a lot mad
do u have solutions for another problem

 

[nirjhar]

Ur 2nd answer is
1.click on colomn tab like A,B,C...
2. Then fill color

thank u

i can not understand your 1st question

 

[kunaltech]

Ur 2nd answer is
1.click on colomn tab like A,B,C...
2. Then fill color

thank u

i can not understand your 1st question

i mean to say that suppose i have a row from 1 to 10 and in that 1 to 3 are color with red and then 4-7 with yellow and 7- 10 with green. in these case i can count manually but if their is case of 1000 rows and column then how do i count.

 

[pillainp]

Hello Experts,

I have 2 doubts in excel sheet.

1) i want to count no of colors i.e. how many rows/columns with blue color or red or white color.

2) i want to highlight particular column with some color if that value is set true/false

pls help me out with this

thanks in advance
Krunal Mehta

Your answer to Problem 1:
A A Simple Google Search

Your answer to Problem 2:
Use conditional formatting to change color of a cell based on its contents.

 

[koolbluez]

Another doubt...
Whenever I make a sheet, suppose i merge 2 or more cells in a column, and then filter them, choose a merged cell element as filter, i expect all the rows with that merged cell to be seen, but i only get the first row of that merged cell.
How can i get all the rows belonging to the merged cell?

Cant be more specific... but hope u understand...

See this... it's filtered.. but not what i want...