Formula Results

[hoggsy]

Hi

I am using =mid to pull data into a table from a worksheet, the data that is pulled across should fall between certain ranges and i was wondering if there was a way to either make the test bold or add a * if it fell out of range.
I tried conditional formating but it wouldnt work as the cell had the formula in it.

Sorry of i didnt make myself very clear.

Thanks

 

[Jonmo1]

Conditional formatting should work...

The problem is probably because you're using the MID function. That returns a TEXT STRING Number, not a real number. But conditional formatting will be looking for a number to do the less than and greater than test...

Whatever your MID function is, try adding +0 to the end of it.

Hope that helps..

 

[hoggsy]

Thanks, that worked like a treat, but it did take me a while to figure out how to hide the #VALUE! error. On the flip side its two new things learnt how to do