Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
How do I format color and font to a logical statement result?
For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
hi
it is possible to have multiple formats in a cell but only with static data such as text or numbers stored as text. It is not possible with data that changes or may vary from time to time such as number, dates and formulas. reason. to have multiple formats requires specific start and stop points within the cell. formula could have a few characters to many many characters but only return a single digit on monday and 10 digits on friday. date change daily. at the beginning of the month a data may be 8 characters and at the end of the month, 10 characters. the specific start and stop points do not adjust as data changes so it is not possible to have multiple formats with formulas, dates and numbers. sorry regards FSt1 "STRAC" wrote: How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Very easy with conditional formatting; you can set whatever formatting
you like including font, text color, fill color, etc. On Jan 17, 2:13 pm, STRAC wrote: How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Select the entire range, go to FormatConditional FormattingCell Value
IsEqual To"INVALID". Click on format and choose the pattern and font style. Thanks "STRAC" wrote in message ... How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Select the column that contains these formulas, click Format/Conditional
Formatting from Excel's menu; select "Cell Value Is" from the first drop down field, select "equal to" in the second drop down field and put ="INVALID" in the third fill-in field; click the Format button, and select Bold from the Font tab and your red color from the Patterns tab on the dialog box that appears; then OK your way back to the spreadsheet. Rick "STRAC" wrote in message ... How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Thank-You!!
" wrote: Very easy with conditional formatting; you can set whatever formatting you like including font, text color, fill color, etc. On Jan 17, 2:13 pm, STRAC wrote: How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Thank-You!!
"Gaurav" wrote: Select the entire range, go to FormatConditional FormattingCell Value IsEqual To"INVALID". Click on format and choose the pattern and font style. Thanks "STRAC" wrote in message ... How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting color and font to a logical statement result?
Thank-You!!
"Rick Rothstein (MVP - VB)" wrote: Select the column that contains these formulas, click Format/Conditional Formatting from Excel's menu; select "Cell Value Is" from the first drop down field, select "equal to" in the second drop down field and put ="INVALID" in the third fill-in field; click the Format button, and select Bold from the Font tab and your red color from the Patterns tab on the dialog box that appears; then OK your way back to the spreadsheet. Rick "STRAC" wrote in message ... How do I format color and font to a logical statement result? For example my formula is: =IF(M199360,"INVALID","OK"), I want the "INVALID" to really stand out on the spreadsheet by bolding it and changing the default color to red. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical test in IF statement returning incorrect result | Excel Worksheet Functions | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
If statement to test font color | Excel Discussion (Misc queries) | |||
Comparison result changes font color | Excel Worksheet Functions | |||
Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions |