Condtional Format

1

123

Thank you

If you could please easy code...

this example in data sheet form sorted by ID I want to put expression in department field for every group of number related to each other give it new back color... you see in this example 3 field take blue color and 3 field take red color.. and if this group of number consist from ONE ROW live it without any color default is White.

ID Department

1 6

2 6

3 6

4 5

5 5

6 5

7 1 now color because one field

8 1 now color because one field

9 6

10 6

11 5

every group take new color?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top