Hi Tracy,

Thanks for your reply.I have tried the same earlier, but it is not covering the whole view and also i need 3 different values to same background color.

Apart from that the other requirement is it is only painting only single row of different value.

find the attached.This is a very basic function.

It should like if value = 'x' then color(varaible,)

You can check.

Thanks,

Ranjan

Hi Tracy,

Thanks for your reply.I have attached the file.

For sheet 26, column Businessalignment,for strong,moderate and weak, different background color is required.

for column 34, different color required for group of values.

This will be as per my prevous 2 JPG attachment.

Thanks,

Ranjan

Hi Jonathan,

Thanks for your advice and help.

I can update tomorrow or day after tomorrow. I am on leave.

Thanks,

Ranjan

Hi Jonathan,

Thanks for your reply. I reproduced, i was sticking with size increase for cover and legend recoloring.

But the next one, I believe is little complex which is present in sheet no.26 business alignment and Financial or Technology Management Strength.

As you suggested about highlight table, i have been through it works only in case of measure, I need your suggestion, whether it is possible to convert dimension to measure and place it on the facts and then do recoloring.I have converted measure to dim. and then reconverted to place measure in between dimension. Similar provision is possible for dimension to be converted to measure to achive our objective.As highlight works on single measure, i can do blending to achive my objective. But biggest question is converting dimensiion to measure and then reconvert back without touching the structure.

Please suggest.

Thanks,

Ranjan

Hi Jonathan,

Just hold one. I am posting further.

Measue i am able to the same by using function max(),still not happening.Let me try further.I need two highlight on two dimensions.

Thanks,

Ranjan