G'day all,
Bit of a curly one. I am hoping to have a sheet code that might be able to achieve the following.
Range of cells may include the following values - EDO or EDO-U
If any of those cells are changed from those values to any value containing a 0, I would like the formatting of that cell to be changed. I can't use a simple conditional formatting rule because there are other cells in the range which may already have a value containing 0, and the formatting needs be different.
Any ideas on if and how this might be able to be achieved?
Cheers
Hayden
Bit of a curly one. I am hoping to have a sheet code that might be able to achieve the following.
Range of cells may include the following values - EDO or EDO-U
If any of those cells are changed from those values to any value containing a 0, I would like the formatting of that cell to be changed. I can't use a simple conditional formatting rule because there are other cells in the range which may already have a value containing 0, and the formatting needs be different.
Any ideas on if and how this might be able to be achieved?
Cheers
Hayden