I know this has been posted for several days, but if you still need an
idea try this.

First, select all cells by clicking in the small gray box to the left
of column A and just above row 1. Pick Format Conditional Format and
select Formula Is and enter =$G1="W" along with the formatting for
Purple cell with white text as mentioned earlier by Kassie.

Next, select the entire column A by clicking on the column header A.
Pick Format Conditional Format and select Formula Is and enter
=$G1="B" along with the formatting for bold text, again, as mentioned
earlier by Kassie.

The first step will format all cells within the same row that contains
the "W". the second step will format text as bold for cells in column A
only if the cell in column G, in the same row, contains the "B".


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=552671