• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting


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


Peter Bartholomew

Well-Known Member
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.


Peter Bartholomew

Well-Known Member
Was the :p 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

Well-Known Member
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.