Conditional Formatting problem 1

[SacreBleu]

Is the following possible without using VB or macros?

Suppose cell B1 has conditional formatting, such as Cell Value is not equal to cell A1. Now, I need to copy and paste B1 every 10th row, numerous times, down the spreadsheet.

What results, such as in cell B11, the conditional formatting copies as Cell Value is "not equal" to cell A1.
However, I need it to be "not equal" to cell A11 (every value in the A column, A1, A11, A21 will differ).

 

[GregLocock]

If you look at your conditional formatting dialog box for some reason the cell address gets set to absolute (ie $A$1). Just get rid of the dollar signs before you copy it and Roberta's your aunt.



Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[SacreBleu]

Greg,
The cell address was actually set (unknown to me) as "A1", not $A$1.
(I have no idea what the significance of the quote marks is)

I then removed the quote marks, and as you already knew, problem solved easily.

thanks!!!

 

[brengine]

The quote marks meant that the A1 was treated as text rather than a formula/cell address.

Ken

 

[SacreBleu]

Thanks Ken, that is useful information.