Excel Sheet Doubt

Status
Not open for further replies.

kunaltech

Journeyman
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

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

nirjhar

Broken In
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
 
Last edited:
OP
K

kunaltech

Journeyman
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

Broken In
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

Šupər♂ - 超人
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...
 
Status
Not open for further replies.
Top Bottom