Select Columns B:M or wherever

FormatCFFormula is:

=OFFSET(B1,0, -1)="a"

Format to red.


Gord Dibben MS Excel MVP

On Thu, 9 Oct 2008 14:14:01 -0700, cougarflank
wrote:

I would like to make it so that I can just set the conditional format for the
whole spreadsheet. So when an "a" is entered into any cell, the cell next to
it automatically is colored red as well.

"John C" wrote:

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.