Conditional Formatting

[Juniad]

Hi Dears!
i have sheet with room number i would like to highlight the row room wise but condition is one room should highlight and next should remain same then next should highlight and so on.
attached the sheet with manual result

 

[GraH - Guido]

Hi @Juniad,

With a helper columns it becomes easy. See if that works for you.

 

[Peter Bartholomew]

An alternative strategy that doesn't require the use of an accumulated helper column is to use a visually 'strong' border style and have the conditional formatting replace it with something more muted when the room number is the same as the next.

 

[GraH - Guido]

Peter dear, how disappointing. No name manager wit or obscure DAF/LET?

 

[Peter Bartholomew]

Guido
Was the your comment or my anticipated reply?

I think that conditional formatting needs a major update. If you try to apply a conditional format to a named range (any range, not even a dynamic range) and does it do what you request? Not a chance; the name gets replaced by one of those sordid little expressions with dollars & colons -- and letters used where any sane person would put a numeric column index!

If you want a slightly out of the ordinary conditional format, try applying the formula =isDynamicArray? to the range =R1:R1048576, where 'isDynamicArray?' is defined to refer to
= ISREF(Sheet1!RC DArray#)
Then just sit back and watch the dynamic array ebb and flow!

 

[GraH - Guido]

Haha, my comment it was nothing more.

I second that. I've been annoyed more then once, the CF does not accept named ranges all that well.

Then you scare me. June release will hopefully bring me to the function with hashtag club.