Auto format cells based on the value of another cell

[lhickerson]

I have one cell "F25" on "Sheet 1" that has three options from a Drop Down List - "USF", "RSF", "GSF".

I would like to auto format multiple cells on multiple tabs in different ranges based on the selection chosen in this cell.

As an example:

If "F25" = "USF", I want:
-- Cell "AG23 on "Sheet2", to be formatted as #,##0 "USF"
-- Cell "AG24"on "Sheet2", to read "$/USF"
-- Cells "AG27:AG2575" on "Sheet2", to be formatted as $#,##0.00 "/ USF"

If "F25" = "GSF", I want:
-- Cell "AG23 on "Sheet2", to be formatted as #,##0 "GSF"
-- Cell "AG24"on "Sheet2", to read "$/GSF"
-- Cells "AG27:AG2575" on "Sheet2", to be formatted as $#,##0.00 "/ GSF"

If "F25" = "RSF", I want:
-- Cell "AG23 on "Sheet2", to be formatted as #,##0 "RSF"
-- Cell "AG24"on "Sheet2", to read "$/RSF"
-- Cells "AG27:AG2575" on "Sheet2", to be formatted as $#,##0.00 "/ RSF"

Can you please help me write code for this?

[lhickerson]

Can anyone help me out with this?