Please help urgent....!!!!

[#1]

I am having a xlsx sheet which looks like this:

Here with the help of qlikview i want to count number of yellow  and Red color cells w.r.t each person horizontaly in all the sheets i.e 1,2 & 3.

For example:

Amit is having:

Yellow      Red

3                3

Please help me to get this result in qlikview.

[#2]

Hi,

You can use the same expression to take a count of the cells, which is used for colour coding.

Regards,

Neha

[#3]

Hi Neha,

Im new to qlikview.

Plz can you share exact expression for Column color.

Thanks,

Prabhu ch

[Gysbert_Wassenaar]

Qlikview can't read the cell formating from excel. It can only read in the values of the cells, not the color of the cells.

[#5]

Thanks Gysbert...........

[er_mohit]

if you wants to change the format or  using colour function then in click on expressions icon minimize side on the left ang then you can change the colour.

hope this helpyou......