Jack-P-Winner
Member
I want to be able to color code cells in a column based upon certain criteria. For example, if I have the numbers 2-4-6 vertically I want to color code them yellow with blue font and a blue border. If someone can show me how o do 1 I can o the rest. I have several columns with 3000 rows in each that I will be coding
In the example you can see in AE:8 through AE:10 or AS:13 - AS:15. I have the 246 color coded. I want to be able to color code all the 246 on a sheet but I do not want to capture every 2,4,6. Only the ones in a vertical row. Another example would be the 6622 in AE:11 - AE:14 or AL:10 through AL:13.
How can I write the conditional formatting to do this?
Thanks Guru's
In the example you can see in AE:8 through AE:10 or AS:13 - AS:15. I have the 246 color coded. I want to be able to color code all the 246 on a sheet but I do not want to capture every 2,4,6. Only the ones in a vertical row. Another example would be the 6622 in AE:11 - AE:14 or AL:10 through AL:13.
How can I write the conditional formatting to do this?
Thanks Guru's