I need assistance with coding conditional formatting using VBA, as the formatting requirements exceed the 3 condtion limit built into excel. I need help establishing a pattern of coding so that I can add several conditions based on cell values (which may or may not be related). For instance:

1) If the value of the cell in column "B" in a given row is "LOCKED", format that cell with fc = 9: fb = True: bc = 16 AND cells C-AA of that row with bc = 35

OR

if the value is "DONE", format that cell with fc = 4: fb = True: bc = 1 , but leaving the bc of cells C-AA at 35.

2) If the value of the cell in column "D" in a given row is "PROD", format that cell with fc = 44: fb = True: bc = 3 AND cells C-AA of that row with bc = 44

...and so on. Any help is greatly appreciated.