this shouldn't be difficult...conditional formatting

  • Thread starter Thread starter bbj123
  • Start date Start date
B

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!
 
Hmm...

CF1: Cell Value is greater than 100%

or, equivalently,

CF1: Cell Value is greater than 1


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