Replace formulas and formatting for 5K cells

[tktmastr]

Hello!

I have a seating chart in Excel that used to shade each seat based on the # of times it was sold using a COUNTIF formula. Now I need to change the formula to a VLOOKUP and the label on the seat.

Each cell/seat used to be 1A1, 1A2, and now they are 1 / A / 1, and 1 / A / 2

Example:

Section 1, Row A, Seat 1, formula used to be =COUNTIF(SEATDATA!A:A,"1A1") and now I need it to be =VLOOKUP("1 / A / 1",SEATDATA!A:D,4,FALSE)

I've also attached an example. The seats in green I've already changed. Is there anyway to change without going through all 5,000 seats manually?

THANKS!

[cubangt]

If its a one time thing, you can simply use the "Find and Replace" and make sure to select "formulas" from the drop down..
Provide the old formula(completely)
Provide the new formula(completely)

and then click Find Next to try against one cell, if it works as you expect, then do the replace all and you are done.