[xpost][/xpost]
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
Thanks, I'll have a look at your workbook.
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 
Don’t have an account yet? Register yourself now and be a part of our community!