Quote (MidnightRider @ Jul 2 2013 01:16pm)

I am attempting to apply conditional formatting to an Excel spreadsheet on a row by row basis.

For each row that contains a value, I would like to search the row for duplicate values and format any duplicates.

I know this could be done by hand simply by manually applying conditional formatting to each row (either writing the formula longways or using the format painter), but there must be a way to automate the process.

If there isn't an easy way to do this within Excel's GUI, I'm guessing there is in VB (in which I have no experience).

Any insight?

Quote (carteblanche @ Jul 4 2013 05:16pm)

i'm not clear what you're trying to do. if you have a formula already that works for a single row, why can't you just apply it to the others?

Quote (carteblanche @ Jul 4 2013 05:38pm)

this is what i'm not understanding. why can't you just copy the formula? drag the corner to all the rows? i can do that with calcultaion formulas, so i figured it works for all formulas

http://www.youtube.com/watch?v=_d_whmDNAEE

Quote (MidnightRider @ Jul 4 2013 06:27pm)

Ahh ok.
The problem is that I haven't actually written a formula to search for duplicates because excel already has a conditional formatting option which does exactly what I'm looking to do.   

However, as far as I know, conditional formatting is applied to a range based on your selection, so selecting the rest of the worksheet would apply the formatting to that entire range, rather than the range =$1:$1, =$2: $2...etc.

Quote (carteblanche @ Jul 4 2013 07:37pm)

the $ is an anchor so the formula acts on the exact column/row/cell. so remove the $ if you want it to apply to the active row or column instead of that specific one