colour coding cells

I am trying to colour code a cell if they are both of the same value.

ie: if cell j2 is the same as cell k2 then colour cell j2 red.

ie if cell j2 is 4 and cell k2 is 4 then colour cell j2 red

can this be done ?

Hi and welcome to the board

Yes it can Have a look at conditional formatting

Sorry but that don't make sence whats the $ mean?

do i have to do that for each cell as i have 18 to do or is there a quicker way of doing it


ie k5 is the same as g5 then hightlight in red
ie k6 is the same as g6 then hightlight in red
ie k7 is the same as g7 then hightlight in red and so on down to k23

Starting with Teylyn's answer select cells k5 to k23 and enter the conditional formatting as

=$K5=$J5

and follow the described way

ok can't get this to work this is what i am trying to do.It's a golf score card and in one column i have the pars and the other columns i input there score when there score = the par I want it to turn red.I am able to do it cell by cell in conditional formatting but there are 9 games a month which means i have to do 9 times 18 cells(162cells) Individually per player is there a quicker way of doing this?

I really don't understand why OPs are reluctant to post a sample workbook.
I see this all the time where there are 10 or more messages back and forth while everyone's trying to clarify and explain and nothing gets resolved.
Eventually someone will suggest to post a sample workbook and the problem gets resolved quickly thereafter.

gazza uk: Post a sample workbook to get faster resolution.

modytrane.

Ok here we go what i am trying to do is if a person gets a par i want it to colour it red automatically.now i know you do this in conditional formatting ex =g4=i4 format red but how do you do it for the whole sheet

Thanks Gos-c i managed to work out how to do it column by column by draging the curser down from say k2 to k20 but when i try to do more than 1 column it just turns the selected cells red so it took me a bit longer but job done many thanks gazza