PDA

View Full Version : Solved: Conditional formatting query



francri
04-06-2011, 05:56 AM
Hi there,

Could somebody please help me with a conditional formatting query?

I would like to do the following;

If I have a row of data from A2 through to T2, then I would like all cells A2 - T2 to be bordered if A2 is not blank (if A2 is blank then no border on cells), I then need this conditional formatting rule to be copied down to row 200.

Any help gratefully received

Thanks

Bob Phillips
04-06-2011, 08:08 AM
Select A2:T200, go to CF, add a formula of

=A2<>""

and then set the formatting as required.

francri
04-06-2011, 09:17 AM
Select A2:T200, go to CF, add a formula of

=A2<>""

and then set the formatting as required.

Thanks xld, that works if I want the whole range to be formatted if there is a value in cell A2. I should have explained better.

I would like each row to be formatted if column A for that row is not blank.

e.g. if A2<>"" then A2 - T2 get formatted then same for next row

if A3<>"" then A3 - T3 get formatted all the way down to row 200

I hope this is more clear, apologies

Francri

Bob Phillips
04-06-2011, 09:23 AM
That is exactly what I gave you. As long as you enter $A2, not $A$2 it will vary depending upon A2, A3, ...

shrivallabha
04-06-2011, 09:25 AM
Even then you can use Bob's Formula. Only change that you need to do is to set the above formula for Cells A2 and T2. Once you are done with that Copy these two cells and then do Paste Special [Formats] upto Cells A200.

Excel will automatically update the formula.

francri
04-06-2011, 09:43 AM
That is exactly what I gave you. As long as you enter $A2, not $A$2 it will vary depending upon A2, A3, ...

Thanks xld, I had been using $A$2 without even thinking.

very much appreciated. I will mark as solved.