View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
bbj123 bbj123 is offline
external usenet poster
 
Posts: 2
Default 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!