conditional formatting help

[tanglin10]

Hi guys i'm trying to write a code whereby conditional formatting can be applied based on a value in column J if more than or equal to one column K cell colour will be changed to blue .:dunno

[tanglin10]

macro* as normal conditional formatting doesn't continually search column J

[tanglin10]

macro* as normal conditional formatting doesn't continually search column J

Hope its not too confusing :(

[sdruley]

Column1 J K L 2 3 4 4 4 2 5 6 5 1 6 5 6 1 7 8 7 0 8 2 8 1 9 4 9 2 10 9 0 1 11 9 2 1 12 0 3 0 13 RECOMMEND HELPER COLUMN L 14 CELL L4 = COUNTIF(J:J,K4)

I apologize that this came out his way. I don't have enough posts to send a picture. I will repost again.

[sdruley]

http://content.screencast.com/users/sdruley/folders/Snagit/media/14c964de-a780-4d29-b954-cc95d3e014e4/01.21.2013-17.12.45.bmp (http://screencast.com/t/CWEFhgcKWrr)
http://screencast.com/t/CWEFhgcKWrr (http://screencast.com/t/CWEFhgcKWrr)