How do I change text color in Excel using a new conditional formatting rule of the form “Format all cells based on their values” without VBA?

I have a situation in Excel where I want to use conditional formatting to change the text color based on cells values so the lowest values become red, and they get progressively bluer as the values increase. I’d like to use the “Format cells based on their values” option in Conditional Formatting->New Rule… . But the only option I see there is to change background color (along with data bars and icons sets, which are of equally no use to me), not text color :
enter image description here

The other five options:

enter image description here

all contain a choice to select a format (the Format…) button, but, for some reason, not the “Format all cells based on their values” option.

I would like a way to use “Format all cells based on their values” to change text color, not background color or anything else. But, strangely, this doesn’t seem to be an option.

Can, and, if so, how can this be done without VBA?

(This question: Format Text in Cells is similar but from 8 years ago and only provides VBA methods. It seems like this should be doable without VBA, but, if not, I’ll use one of those methods.)

P.S. I’m new-ish to conditional formatting so my apologies if I’m missing something obvious.

Thanks!