Formatting color and font to a logical statement result?

  • Thread starter Thread starter STRAC
  • Start date Start date
S

STRAC

How do I format color and font to a logical statement result?

For example my formula is: =IF(M199>360,"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?
 
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
 
Very easy with conditional formatting; you can set whatever formatting
you like including font, text color, fill color, etc.
 
Select the entire range, go to Format>Conditional Formatting>Cell Value
Is>Equal To>"INVALID". Click on format and choose the pattern and font
style.

Thanks
 
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
 
Thank-You!!

Gaurav said:
Select the entire range, go to Format>Conditional Formatting>Cell Value
Is>Equal To>"INVALID". Click on format and choose the pattern and font
style.

Thanks
Click to expand...
 
Thank-You!!

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top