Hi!
I'm trying to find numbers in my cells that are less than 128 and replace them with the number 128. I've tried Find and Replace, and it doesn't understand "less than", as far as I can tell. I've also tried conditionally formatting the cells that have numbers less than 128 so they're purple, but haven't figured out a way to put "128" in only these purple cells. Does anyone know how to do this??
Thanks!!
Brooke
I'm trying to find numbers in my cells that are less than 128 and replace them with the number 128. I've tried Find and Replace, and it doesn't understand "less than", as far as I can tell. I've also tried conditionally formatting the cells that have numbers less than 128 so they're purple, but haven't figured out a way to put "128" in only these purple cells. Does anyone know how to do this??
Thanks!!
Brooke