Hmm...

CF1: Cell Value is greater than 100%

or, equivalently,

CF1: Cell Value is greater than 1


works for me.


In article ,
bbj123 wrote:

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!