I have a spreadsheet with data on Column A to F.

If the value of any cell on Column A is "P", I would like to have cell A to F on the corresponding row be filled with color. For example, if Cell A1 is "P", then Cell A1 to F1 will be filled with color.

Any suggestion would be appreciated. Thanks...