Macro and Conditional formating problem. Please help!

[11ktran44]

Kim Sample.xlsxHello:

1. I am trying to format a row based on another row values. I does not work! It only work if I do formating of one cell.
2. How do I do a macro that can rearrange information from raw data sheet? I hard to expalin. Please see attached file.

I am not a programmer, but I really want to learn and to achieve this goal. Your kind help are greatly appreciated.

Kim A