have some information that gets populated on one sheet in Range (A10:E52) Columns (A-E) are merged together:
What I want is if the text in That row 10-52 in column A = contains Certain text then it would Format the row a certain Way.
text to match is: (These are Descriptions that get brought through so I would like if they exist to change the format to have a better look.
Operating/Standby Charges
Inspections
3rd Party Tools/Subs
Miscellaneous Charges
Core Charges
example for row formatting: if that text is found then format : (format and shade the Row Grey - From column (A:O) and Bold text and Remove the Center Borders also change row height to 18.
Every time this runs it would have to reset the Range (a10:o54) back to Normal ( Times New roman, No Bold, font #10, no Fill color & row Height to 24) that way when the category name comes thru in a different location the ending result is correct.
I have the desired output on Job Ticket tab of my attachment
Once I have something to try I will need to make additions and check out the results then Make a reply as to how it is working
Bookmarks