Conditional formatting in Excel

[bcselect]

I have a workbook with multiple sheets. I'm trying to write a conditional formula that does as follows:

Sheet1 has Lname in Column C, Fname in column D
Sheet2 has Lname in Col A, Fname in Col B (both sheets in alphabetical order)
Sheet2 has Col D & Col L with numbers

I need to check D & L and if either one is below a certain number, format (font color) on Sheet1 C & D
This is what I have so far but doesn't work correctly.

Help please

Format values where this formula is true:

=OR('Sheet2'!$D7<7,'Tournament Eligibility'!$L7<3)

Applies to:

='Sheet1'!$C$22:$D$221

 

[6StringJazzer]

Are the lists for Lname and Fname in both sheets exactly the same? Or could there be names in one that are missing in the other? This will determine if you can reference the same row, or whether you will have to do some kind of lookup.

If the lists are exactly the same then your rule should be

=OR('Sheet2'!$D22<7,'Tournament Eligibility'!$L22<3)

The row reference needs to be the first row of the Applies To range.

Also your formula refers to a sheet called Tournament Eligibility which isn't mentioned at all in your description, so that's a problem too.

 

[bcselect]

I have a workbook with multiple sheets. I'm trying to write a conditional formula that does as follows:

Sheet1 has Lname in Column C, Fname in column D
Sheet2 has Lname in Col A, Fname in Col B (both sheets in alphabetical order)
Sheet2 has Col D & Col L with numbers

I need to check D & L and if either one is below a certain number, format (font color) on Sheet1 C & D
This is what I have so far but doesn't work correctly.

Help please

Format values where this formula is true:

=OR('Sheet2'!$D7<7,'Tournament Eligibility'!$L7<3)

Applies to:

='Sheet1'!$C$22:$D$221

yes the 2 sets 0f columns are identical. I dont see any difference in your suggested code and mine. You can replace Tournament eligibility with Sheet 2

 

[6StringJazzer]

The difference between our formulas is highlighted in bold red. My formula starts in row 22, because that is where your Applies To range starts. Your formula starts in row 7, for reasons I don't know, and it won't work.