M
MM
Hi,
Help Please!
I've set up a sheet with conditional formatting to alter/ensure that the
data input fits into the format I want. This is working fine when the data
is "manually" input, but where the data in copied from another sheet, the
conditions that I've applied aren't applying - how can I ensure that the data
copied from another sheet amend the data to the conditions that I want to
apply?
E.g - I've set up conditional formatting to ensure that a figure to try and
ensure that the input value is between 5 and 7, (anything outside this range
I've set conditional formatting to bold it in RED). Yet when data is copied
to this cell (outside this range) the conditional formatting doesn't work.
Hope this makes sense!
Thanks,
MM
Help Please!
I've set up a sheet with conditional formatting to alter/ensure that the
data input fits into the format I want. This is working fine when the data
is "manually" input, but where the data in copied from another sheet, the
conditions that I've applied aren't applying - how can I ensure that the data
copied from another sheet amend the data to the conditions that I want to
apply?
E.g - I've set up conditional formatting to ensure that a figure to try and
ensure that the input value is between 5 and 7, (anything outside this range
I've set conditional formatting to bold it in RED). Yet when data is copied
to this cell (outside this range) the conditional formatting doesn't work.
Hope this makes sense!
Thanks,
MM