MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
hi,
i would like to do condition formatting on between function on vba.
i would like to set between cells on lower and upper to determine which is out of tolerates on my data by red (out of spec).
the condition formatting is not consistent on determine my data is out or not here the example.
Welcome to Ozgrid. I think you need to explain more fully what you want.
Welcome to Ozgrid. I think you need to explain more fully what you want.
what i really want is to use condition reformatting on lower and upper limits to determine my results as red(oversize or undersize) using vba. i want use vba to set cells as my lower and upper limit to show the results as it not between that values i type in.
shown below for example
Can you attach an example workbook
Can you attach an example workbook
example attached to it. currently my format is using condition reformatting function. i want change it vba and let the set cells value to show the results with colour to show that which is in or out of the minimal and maximum.
sorry, i will post the link next time.
Thanks, I'll have a look at your workbook.
Thanks, I'll have a look at your workbook.
thank you and did you find any clue yet?
You don't need VBA to do this.
You can using "Using a formala to determine which cells to format" in "New formatting rule" tab.
First you create rule follow this method with formula "=AND($J$13<$G$13,$J$13>$H$13)" for the cell J13, and format the font to red color as you want then you can use format painter to apply for the other cells. Hope it can help 
