Hi,

Thanks for looking at my query.
Does anyone knows how to prioritze row based upon the cell value. That is

1. I have pivot table in sheet 2 which is linked to sheet 1. I am using pivot table as report.
2. I have a coloumn in pivot table as urgency which is linked to sheet 1 urgency .
3. Everyday i need to enter multiple row data in sheet1 which will replicate in pivot table in sheet 2
4. If i select high priority in sheet 1 , it shows high priority in pivot table in sheet 2 as well but i would like to highlight it in red and bring on the top row of the pivot table.
5. If i select medium priority in sheet 1, it shows medium priority in pivot table in sheet 2 as well but i would like to highlight it in amber and bring below the high proprity row.
6. If i select low priority in sheet 1, it shows low priority in pivot table in sheet 2 as well but i would like to highlight it in green and show below medium priority row.

Please help me guys,
~Thanks in advance