| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition font color in a single cell based on its formula data.
I have a formula within a single cell that contains a formula to sum up a
column. I want that same cell to reflect its sum data in red font if the sum is less than 35 and green font if the sum is equal to or greater than 35. How can I do this? Please help. Thank you, in advance, for your time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condition font color in a single cell based on its formula data.
FormatConditional Formatting.
Cell value is <35 format to red font. AddCondition 2 Cell Value is equal to or greater than 35 format to green font Gord Dibben MS Excel MVP On Thu, 14 Feb 2008 13:33:03 -0800, Bee wrote: I have a formula within a single cell that contains a formula to sum up a column. I want that same cell to reflect its sum data in red font if the sum is less than 35 and green font if the sum is equal to or greater than 35. How can I do this? Please help. Thank you, in advance, for your time. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condition font color in a single cell based on its formula dat
Thank you so much. I'm retired and had forgotten how to format conditions in
a cell. I remembered how shortly after I posted my question and then didn't know how to cancel the posting!! I appreciate your reply and time. "Gord Dibben" wrote: FormatConditional Formatting. Cell value is <35 format to red font. AddCondition 2 Cell Value is equal to or greater than 35 format to green font Gord Dibben MS Excel MVP On Thu, 14 Feb 2008 13:33:03 -0800, Bee wrote: I have a formula within a single cell that contains a formula to sum up a column. I want that same cell to reflect its sum data in red font if the sum is less than 35 and green font if the sum is equal to or greater than 35. How can I do this? Please help. Thank you, in advance, for your time. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Condition font color in a single cell based on its formula dat
You cannot cancel postings after you hit the "go" button.
Gord On Mon, 18 Feb 2008 01:48:00 -0800, Bee wrote: Thank you so much. I'm retired and had forgotten how to format conditions in a cell. I remembered how shortly after I posted my question and then didn't know how to cancel the posting!! I appreciate your reply and time. "Gord Dibben" wrote: FormatConditional Formatting. Cell value is <35 format to red font. AddCondition 2 Cell Value is equal to or greater than 35 format to green font Gord Dibben MS Excel MVP On Thu, 14 Feb 2008 13:33:03 -0800, Bee wrote: I have a formula within a single cell that contains a formula to sum up a column. I want that same cell to reflect its sum data in red font if the sum is less than 35 and green font if the sum is equal to or greater than 35. How can I do this? Please help. Thank you, in advance, for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change row font color based on cell value in that row | Excel Worksheet Functions | |||
| How to sum data based on font or cell color? | Excel Worksheet Functions | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| change font color of cell based on critera | Excel Worksheet Functions | |||
Linear Mode
