Conditional Formatting problem
Conditional Formatting problem
(OP)
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).
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).





RE: Conditional Formatting problem
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Conditional Formatting problem
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!!!
RE: Conditional Formatting problem
Ken
RE: Conditional Formatting problem