VBA code ,Autofill color of a column based on cell value

Need VBA code to autofill color of a cell based on cell value... not conditional formatting.
when i write "ok" in column "G" the autofill color of cell will become "green" , if i write "OA" the autofill color will become "red".

Please Login or Register  to view this content.

Thanks its solved

Glad I could help. Please update the thread as Solved.