this shouldn't be difficult...conditional formatting
 

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!

this shouldn't be difficult...conditional formatting
 

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!

this shouldn't be difficult...conditional formatting
 

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

"JE McGimpsey" wrote:

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!