Forum Discussion
FORMULA not working with conditional format
Thanks for the clarification. See the attached version.
You had rules for most individual rows; I have reduced it to 4 rules for the entire range.
sorry, I should have explained it better ! the idea is to save time on manual entry of results, i want to have column B to be automatically filled in the results area. it will only be the single values this will work on. it doesn't matter if the results copied has text or two numbers separated with "/" as these will be manually typed over, as it isn't correct to the in-between value like you said. so please ignore these. it is only the single values EG rows: 24 - 26 I am interested in. I am not sure if i need a value function somewhere ?
Thanks for the clarification. See the attached version.
You had rules for most individual rows; I have reduced it to 4 rules for the entire range.
- That is perfect. thank you very much. very helpful