What makes the cell colored red? If it is conditional formatting for that
cell, you can just include that in the next cell as well.

B2: =AND(A10,A20) ... formatted as red
C2: =AND(A10,A20,B2="a") ... formatted as red
--
John C


"cougarflank" wrote:

I want to format my spreadsheet so that when a cell has an "a" in it and is
colored red, the cell immediately to its right will also be colored red. Is
this possible through conditional formatting or VBA? Thanks.