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?

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?

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?

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?

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?

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?

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?

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?