Conditional formatting in Table format

[tarek]

Conditional formatting format: Boarder - bottom boarder

The problem when I insert a raw in the middle of the table the condition formatting is not applied. How can I make excel carry over the conditional formatting?

The only reason I formatted the data in a table because it'll automatically control alternating row background color when insert rows.

Thanks in advance for your help

 

[Akashwani]

Hi tarek,

What is your Conditional Formatting formula?
Is it the one Jonmo1 and I gave you earlier?

If it is, then it should work, when you insert a new row.......

Excel Workbook
	A	B	C	D	E	F
1	Numbers	Data1	Data2	*	Check	*
2	35155976	Cat	Red	*	FALSE	*
3	35156348	Dog	Yellow	*	TRUE	*
4	35156348	Pig	Green	*	TRUE	*
5	35160550	Cow	Blue	*	TRUE	*
6	35160550	Rat	Pink	*	TRUE	*
7	35160550	Cat	Orange	*	TRUE	*
8	35160550	Dog	Black	*	TRUE	*
9	35161189	Pig	White	*	TRUE	*
10	35161189	Cow	Purple	*	TRUE	*
11	35161201	Rat	Brown	*	TRUE	*
12	35161201	Cat	Grey	*	TRUE	*
13	*	*	*	*	*	*
Sheet1

New row inserted......

Excel Workbook
	A	B	C	D	E	F
1	Numbers	Data1	Data2	*	Check	*
2	35155976	Cat	Red	*	FALSE	*
3	35156348	Dog	Yellow	*	TRUE	*
4	35156348	Pig	Green	*	TRUE	*
5	35156348	Horse	Tartan	*	TRUE	*
6	35160550	Cow	Blue	*	TRUE	*
7	35160550	Rat	Pink	*	TRUE	*
8	35160550	Cat	Orange	*	TRUE	*
9	35160550	Dog	Black	*	TRUE	*
10	35161189	Pig	White	*	TRUE	*
11	35161189	Cow	Purple	*	TRUE	*
12	35161201	Rat	Brown	*	TRUE	*
13	35161201	Cat	Grey	*	TRUE	*
14	*	*	*	*	*	*
Sheet1

You will see that the cell reference has automatically increased from $A$2:$A$12 to $A$2:$A$13

Does the data you have added in the new row meet your Conditional Formatting rule?!

Ak

 

[tarek]

Sorry Akashwani for not including all the information in my post... here is issue:
I have a set of data formatted in a table: (Main Ribbon – Insert – Table – Create Table), I am also applying the following conditional formatting on my range:
Conditional formatting formula: =NOT($A2=$A3)
Conditional formatting format: Boarder - bottom boarder

The problem when I insert a raw in the middle of the table the condition formatting is not applied. How can I make excel carry over the conditional formatting?

The only reason I formatted the data in a table because it'll automatically control alternating row background color when insert rows.

Thanks in advance for your help

 

[tarek]

Sorry Akashwani for not including all the information in my post... here is issue:
I have a set of data formatted in a table: (Main Ribbon – Insert – Table – Create Table), I am also applying the following conditional formatting on my range:
Conditional formatting formula: =NOT($A2=$A3)
Conditional formatting format: Boarder - bottom boarder

The problem when I insert a raw in the middle of the table the condition formatting is not applied. How can I make excel carry over the conditional formatting?

The only reason I formatted the data in a table because it'll automatically control alternating row background color when insert rows.

Thanks in advance for your help

 

[Akashwani]

Hi tarek

This is sample data, before inserting a new row.......

Excel Workbook
	A	B	C	D
1	Numbers	Data1	Data2
2	35155976	Cat	Red
3	35156348	Dog	Yellow
4	35156348	Pig	Green
5	35156348	Horse	Tartan
6	35160550	Cow	Blue
7	35160550	Rat	Pink
8	35160550	Cat	Orange
9	35160550	Dog	Black
10	35161189	Pig	White
11	35161189	Cow	Purple
12	35161201	Rat	Brown
13	35161201	Cat	Grey
14
Sheet1

After inserting a new row and adding new data to the row........

Excel Workbook
	A	B	C	D
1	Numbers	Data1	Data2
2	35155976	Cat	Red
3	35156348	Dog	Yellow
4	35156348	Pig	Green
5	35156348	Horse	Tartan
6	999999999	Tiger	Polka Dot
7	35160550	Cow	Blue
8	35160550	Rat	Pink
9	35160550	Cat	Orange
10	35160550	Dog	Black
11	35161189	Pig	White
12	35161189	Cow	Purple
13	35161201	Rat	Brown
14	35161201	Cat	Grey
15
Sheet1

Using your formula and a table I cannot replicate your problem, sorry, the Conditional Formatting has been applied.

Sorry, but I cannot give you an answer to this problem.

Ak