Conditional Formatting and list of Criteria

Thanks DaddyLongLegs

But will that also apply to B2:B11 or Z2:Z11?

Will the records for the B column the C column the Z column be affected the same?

Thanks.

Yes, Maurice, that's the idea, isn't that what you want?

The clever thing to do with conditionla formatting is to select the whole range to which you want it to apply FIRST and then the formula will adjust automatically for the other columns, try it and see........

Note: when you select A1:Z1 the "active cell" should be A1 (i.e. when you select that range, select A1 first)

Thanks. I'm going to give it a try.

Sorry, I didn't work. When i tried to follow your instructions, the whole range of Record Numbers was changed when the first column was TRUE.

I've attached the file. I only want that column "heading" the record number for that column alone to highlight.

I tried doing the single column and using the copy handle to copy the condition onto the adjacent cells but that didnt work either.

Thanks. Please help.

Is the only way this can be done is one-by-one?

It has to do with relative cell reference. I typed this into the Search on MS Excel and clicked on "Switch between relative, absolute, and mixed references"

The Dollar Sign defines what is relative and what is absolute. So if i want the column to be Relative, then i remove the $ from in front of the reference. If i want the row to be relative or to change, then i remove the $ from in front of the row number.

So my formular came out to be =COUNTIF(B$7:B$24,"N") without the dollar sign in front of the B column. Instead of $B$7:$B$24 it is B$7:B$24. If i wanted the Column to stay absolute and the row to be relative i would say
$B7:$B24. if i want both to be relative i would say B7:B24.