2010 Conditional Formatting: Cell Color Change, Based on Ratio (1:1)

Greetings!

Newbie here, been reading this site for the past two days hoping to find the right answer, ohh soo close..
I did find several threads that came pretty close, but nothing specifically related to 2010 Conditional Formatting: Cell Color Change, Based on Ratio (1:1).

Simply put, I would like to change the cell color to red, if the ratio falls below 1:1 (i.e. 1:3) and green if the ratio is above 1:1 (i.e. 3:1).

Much appreciated, thank you!

J

Hello James_D welcome to Excel Forum

If your values are actually like 3:1 and 1:3 in a single cell then try using SUBSTITUTE function to replace ":" with "/" to create a fraction, then you can test if it's greater than 1 or not, e.g. for data in column A select that column and use this formula in conditional formatting for red condition

=AND(("0 "&SUBSTITUTE(A1,":","/"))+0<1,A1<>"")

and this one for green

=("0 "&SUBSTITUTE(A1,":","/"))+0>1