Greetings, looking for help to split a cell value. I want to be able to separate value to use lower down the sheet. I arrive at the value using:
= Frequencies!E6&"/"&FrequenciesF6
This give me a cell value of:
3/90
I want to be able to access the separate values, in this case 3 and 90 for use in a conditional format lower down.
Thanks in advance.
H
Bookmarks