Conditional Format

[rizmomin]

Hello:


I have Data in Column D,G,J,M and P.
I want to compare the value is each row ( about 70 Rows) of these column and highlight dark to light color, dark being the highest number in the row and light being the lowest number in the row.

Basically each row would need to be highlighted and will show dark to light color in each cell.

Please let me know if any questions.

Thanks

Riz

[Fotis1991]

See if this take care your needs.

[rizmomin]

Hello Fotis:

Excellent work, but how would I implement in my workbook.
Also like to shade the color in all 5 columns, Dark to Light.

Dark1,Dark2,Darklight,Light2,Light1

I hope you understand what I am saying.

Please help,

Thanks

Riz

[Winon]

Hi rizmomin,

Sorry. Bump!

[Fotis1991]

Hello Fotis:

Excellent work, but how would I implement in my workbook.
Also like to shade the color in all 5 columns, Dark to Light.

Dark1,Dark2,Darklight,Light2,Light1

I hope you understand what I am saying.

Please help,

Thanks

Riz

Apologize, but i don't understand!

[rizmomin]

Hi:

I want to fill color is all 5 columns and the darkness of the color would depend on the value is the cell.

Example:

D3=20
G3=25
J3=15
M3=5
P3=10

In the above Cell
G3=DARKEST Color
D3=Color in between Dark and light
J3=Color in between Dark and light
P3=Color in between Dark and light
M3=Light Color

I hope it is clear now...
Please let me know if any questions.

Thanks

Riz

[Fotis1991]

Yes. It's clear.

Hope my solution to be clear too.

[FDibbins]

an alternative might be to use "format all cells based on their values". select 3-colr scale

[rizmomin]

Hi Fotis:

This would work for me.

Thank you so much..

Riz

[Fotis1991]

You are welcome.

Thanks for the reb*

[Winon]

@ Fotis1991,

Nice work.

[Fotis1991]

@ Fotis1991,

Nice work.

Thank you for your kind words and also for the reb*