| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Difficult conditional formatting | Excel Worksheet Functions | |||
Linear Mode
