Yodelayheewho
Member
I've been wrestling with this and need some help. I am responsible for writing detailed procedures for users.
I've uploaded a sample worksheet that has three tables. The first tables shows the issue I'm having. The next two tables show the results I want.
Notice there are whole numbers in columns D & E. You can see the issue I'm having because they are being highlighted regardless of the number is Column A
I first tried to tackle highlighting rows when column A has a whole number.
The conditional formatting formula I have is: =IF(LEN(A3),MOD(A3,1)=0,"")
Once this works, I would also like to add to the formula, so the color of the row highlighting changes based on the first three letters in cell C1, i.e., "MSO" = green, "ASO" = orange. When entering orders in our system, we must be sure we are in the correct plant from the start. Color coding will help remind the user to start in the correct plant.
Thank you in advance!
I've uploaded a sample worksheet that has three tables. The first tables shows the issue I'm having. The next two tables show the results I want.
Notice there are whole numbers in columns D & E. You can see the issue I'm having because they are being highlighted regardless of the number is Column A
I first tried to tackle highlighting rows when column A has a whole number.
The conditional formatting formula I have is: =IF(LEN(A3),MOD(A3,1)=0,"")
Once this works, I would also like to add to the formula, so the color of the row highlighting changes based on the first three letters in cell C1, i.e., "MSO" = green, "ASO" = orange. When entering orders in our system, we must be sure we are in the correct plant from the start. Color coding will help remind the user to start in the correct plant.
Thank you in advance!