Conditional Formatting help

[Ian1976]

Hi,

I have a table with several columns and rows, is there a method to highlight the cell at the botom of the column in red if there are more than 2 data entries in that column?

Thanks

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]J
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]X
[/TD]
[TD]X
[/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]X
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]RED
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RED
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Mentor82]

Hi
Here's the function I've prepared for you. I assume that your header row is 1 and the data toto count starts from row to. So, select the whole table you have, go to the conditional formatting and place below formula and set the colouring. Let me know if that's ok for you.

=And(A3<>"";COUNTIF(A$2:A$1000;A2)>2)
[\CODE]

 

[Special-K99]

You might be better off placing the colour at the TOP of the column instead of bottom, otherwise you're gonna have to scroll to the lowest row in order to see the colour.

 

[Mentor82]

Hi,
One more thing. For below function select range for conditional formattinf from 2nd row on (without headers) to have it worked properly.

=And(A3<>"";COUNTIF(A$2:A$1000;A2)>2)

 

[Ian1976]

Hi
Here's the function I've prepared for you. I assume that your header row is 1 and the data toto count starts from row to. So, select the whole table you have, go to the conditional formatting and place below formula and set the colouring. Let me know if that's ok for you.

=And(A3<>"";COUNTIF(A$2:A$1000;A2)>2)
[\CODE][/QUOTE]

Thanks Mentor82,

I've put the code in and its working but it highlights cells c2,c3 & c4 but i would like it if it just highlighted the bottom cell i.e C7?

Is that possible? Oh and i used "X" as an example but the cell could contain any text or number?

Thanks
Ian

 

[Ian1976]

Good point! thanks!

 

[Mentor82]

Happy to help

 

[Ian1976]

Any thoughts on the other bit? ???