Forum Discussion
Solved
Use colour to enter a logical value
Hi. I need to put a value into a cell to show we have a repeat caller. I've used the conditional formatting for duplicate numbers (the last part only, so not an exact science), so these have been c...
Jane_at_Stamma Transform your table to a structured Excel table and use a formula like in the "repeat" column to count the number of occurrences of the current caller ID up to the current row. If 1, then this is first time caller. Anything higher than 1, then it's a repeat caller.
By the way, I changed the conditional formatting rules a bit. See attached.
Jane_at_Stamma Not sure what you did but you ended up with three conditional formatting rules that did not cover the entire cli column. Get rid all the rules and create a new one with an "Applies to" range like $E$2:$E$3524 . When you now add data at the bottom of the table the CF rule should expand automatically.
Riny_van_Eekelen thank you! totally sorted. Hopefully we can use this file from here on in to help us track how we are doing on calls 🙂 you've been great!
Jane_at_Stamma You're most welcome!