Conditional Formatting formula if cell has a specific Name?

[ekn]

So for a project I have a column where the cells have the name "Score". Now I need a conditional formatting formula that I can apply to the whole sheet.

Something like highlight cell if(Score<69.5). So I'll apply this to the whole sheet but it will only do the less than function on that one column that has cells named Score.

[popipipo]

=and(a1="score",b1<69.5)
Try this formula

[ekn]

No that didn't work. To be clear I want to highlight that have the name "Score" and a value of less that 69.5.

Is there some way to check the Name of a cell? Like A1.Name()? So I could do if(and(A1.name()="Score",A1<69.5))

(I realize A1.name() isn't how things work in Excel but I have a programming background so that's the only way I know to convey what I'm trying to accomplish to you)

[popipipo]

Can you upload an excel file?