How to get excel to ignore "<" when conditionally formatting?

[hannahexcel]

Hello,

I am trying to conditionally format rows C and D so that excel highlights a value when $D94>$C94 (for rows C94:D118). So that when successful, excel would highlight cells D112 and D116.

However, it seems that the "<" in front of many of the values in column D is throwing off the conditional formatting rule. I would like for Excel to read "<0.095" as "0.095," for "<10" as "10," etc. Does anyone know how I should either format the numbers or define the formula when creating a Conditional Formatting rule?

Thank you! Please let me know if I can clarify anything.

 

[Z51]

Select C94:D94, then use this formula in Conditional Formatting:

=(SUBSTITUTE($D94,"<","")+0)>$C94

 

[hannahexcel]

Select C94:D94, then use this formula in Conditional Formatting:

=(SUBSTITUTE($D94,"<","")+0)>$C94

Thank you so much! That did it.

 

[Omer_K]

Hey,
If I understood you correctly,
will always be the sign less than ?
If so, add another rule:
=$C94<VALUE(RIGHT(D94,LEN(D94)-1))
Don't forget to mark the range of all cells

 

[hannahexcel]

Hey,
If I understood you correctly,
will always be the sign less than ?
If so, add another rule:
=$C94<VALUE(RIGHT(D94,LEN(D94)-1))
Don't forget to mark the range of all cells

Hi there, thanks for your response. Yes, you understood correctly that the sign, if there is one, will always be "less than (<)".
I tried adding your suggested rule, but it doesn't seem to be giving me the desired results--I'm assuming I'm inputting it incorrectly(?)
In theory, how would adding your suggested rule to the one above (=(SUBSTITUTE($D94,"<","")+0)>$C94) change the outcome?