Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm in the process of creating a scheduling template.

I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional formatting (highlighting specific colours based on specific text) I've already implemented. Basically, I'm trying set up the schedule so that the first row of each text is visible, but that repeating rows below only show the highlight (i.e., values suppressed)--something akin to Google Calendar. I've used data validation to create a drop-down menu (of work activities) based on the following list (kept in a separate worksheet). Keep in mind that this is my first go at this sort of thing (I'm likely going to reduce the amount of colour).

share|improve this question

migrated from stackoverflow.com May 4 at 3:33

This question came from our site for professional and enthusiast programmers.

    
The following formula works: =AND(B2=B1,B2="Info Desk") However, it leads to only the bottom row of consecutive repeated values being displayed (what I'm looking for is only the top row being displayed). I've played around with rule order, but have not had any luck. Any advice would be appreciated. –  user3599312 May 3 at 16:55

1 Answer 1

As a seperate rule from your colouring rule, use

=A1=OFFSET(A1,-1,0)

and for the Format, use Number Format, Custom, ;;;

Apply to a range starting at A1

Note: I use OFFSET so that the formating is not broken if you insert a row, as it would be with =A2=A1

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.