Conditional formatting for rows

Is there a conditional formatting function that will format an entire row (or first 30 columns) based on the text or number in a cell?

I get a 100-500 row report every day and I currently use conditional formatting in a macro to highlight individual cells, but it would better if each of the rows were formatted with a yellow fill.

Any ideas?

Example:
A1 ID
B1 RECEIPT_NO
C1 FIRST_NAME
D1 LAST_NAME
E1 SPOUSE_FIRST_NAME
F1 SPOUSE_LAST_NAME
G1 DATE_CREDITED
H1 CREDIT_AMOUNT HIGHLIGHT IF OVER $1000
I1 FIRST_ENTRY HIGHLIGHT IF BEFORE 2001
J1 PRIMARY_STAFF HIGHLIGHT ROW IF SMITH, JONES, TAYLOR
K1 SECONDARY_STAFF
L1 DIVISION HIGHLIGHT ROW IF CATERING, HOSPITALITY, TAXI
M1 UNIT

Hi and welcome to the forum

I am a little unsure as to exactly what you want to highlight here?

to Conditional format an entire row (or entire column) would not be wise because CF becomes very resource-heavy after a while.

To use CF on a range of cells...
1. highlight the range you want to apply the conditional formatting to (say A2:Z200)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =OR(L1=CATERING,L1=HOSPITALITY,L1=TAXI)

If this doesnt work for you, I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.