Conditional formatting and userform

J

jknapp1005

I created a userform to enter data into a worksheet. One of the cells has
conditional formatting that has it auto entering FAIL and turning cell red if
a value entered is less than a certain amount in another cell. It works when
I manually input the data in the worksheet, but the cell fill feature doesn't
work when I input data with the user form.

Why might that be?

I can go ahead and use the sheet without the user form, but I'd rather use
one.
 
Top