this shouldn't be difficult...conditional formatting

[bbj123]

but, i'm an idiot....
column "P" is sum of Columns "C-M" (and formatted for % if that makes any
difference).
i want column "P" text to turn red is value is greater than 100%.
conditional format with value option doesn't work and i don't know what
formula option to use.
please help.
Thank you!

 

[JE McGimpsey]

Hmm...

CF1: Cell Value is greater than 100%

or, equivalently,

CF1: Cell Value is greater than 1


works for me.

 

[bbj123]

That was it...
I wasn't putting "%" in the value box....
Thank you! It worked...of course