According to the Index to Compiled Confederate Military Records as shown on Ancestry.com he enlisted a Corporal in Company A, of the36th TX Cav (Woods).
It also lists the following information about his record from "US Civil War Soldiers" from the National Park Service:
Name: John W. Herndon
Side: Confederate
Regiment State/Origin: Texas
Regiment Name: 36 Texas Cavalry
Regiment Name Expanded: 36th Regiment, Texas Cavalry (Woods')
Company: A
Rank In: Corporal
Rank In Expanded: Corporal
Rank Out: Corporal
Rank Out Expanded: Corporal
Film Number: M227 roll 17