Conditional Formatting with array formula

[kadams99]

I read somewhere that Conditional Formatting evaluates custom formulas as though they were array formula, so you may use array formulas in format conditions. You do not enter them with Ctrl+Shift+Enter in the CF dialog as you normally do in worksheet cells. Excel will always treat a custom formulas in CF as an array formula, even if it is not one.

When I copied my formula with an array to the CF dialog box and clicked Ok, the conditional formatting didn't work. It only worked for the first column of data. Does anyone have experience with this?

What I am trying to do is strike out the rows of data that are not the latest ver. Only the first column was formatted correctly. Is there a way around this? Thanks.

[JBeaucaire]

Is the latest version for any one value always the furthest down in the list?

If so, highlight D14:N79 and apply this CF:

=COUNTIF($D$14:$D14, $D14) <> COUNTIF($D:$D, $D14)

[Tony Valko]

Not real sure how you define what cells should be formatted but...

The formulas entered in column O of the worksheet are different than the formulas used as the conditional formatting rule.

The CF formula references cells on row 14 for every cell to be formatted but the formulas in column O refer to the row that the formula is entered on.

[daddylonglegs]

You have a missing $ in your (conditional formatting) formula - the first D14 must be preceded by $

[kadams99]

Thanks for your comments. I've gone home for the night but will check on this tomorrow.

[kadams99]

Thanks daddylonglegs! That was the issue - I added the missing $ as you pointed out, and it is working perfectly now.

Many Thanks for all your help!