Apply conditional formatting to eg: SORT, UNIQUE, FILTER array formula Cells

[drom]

Hi and Thanks in advance!

I do not want to apply conditional formatting to the entire Columns, just to the dinamic array formula I get when using (SORT, UNIQUE, FILTER...) Formulas

I mean Is it possible to apply conditional formatting to the dinamic array formula cells we get when using formulas like eg:

• SORT
• UNIQUE
• FILTER

Thanks again

 

[6StringJazzer]

Conditional formatting Applies To ranges have to be static ranges. But you could write a formula that includes as a condition whether the cell is part of a dynamic array. So if you were using UNIQUE in a sheet, for example, you could put a condition in the CF formula that determines the range that would be included in the UNIQUE formula and format only those cells that fall within that range. But you would have to replicate the formula.

Your question is kind of generic. The solution will depend on the specifics of each situation.

 

[drom]

Yes
This is the wayI am doing at present
I thought maybe there was one other way
Thanks

 

[Peter_SSs]

This is the wayI am doing at present

Could you give some more detail about exactly what you are "doing at present"?

 

[drom]

I am adding a new column to my array columns
This new column adds the same Cummins plus a a filter to a cell above the heading
(I have included a heading to my arrays)
So I can use the autofilled there

 

[Peter_SSs]

Hmm, that doesn't seem to have anything to do with Conditional Formatting, which is what your thread is about and what I thought you were referring to with the comment I quoted above.

BTW, what is "Cummins"?

 

[6StringJazzer]

BTW, what is "Cummins"?

I am guessing that's what happens when you try to type "columns" on a phone