Font Colour

[Andries]

Hi Everybody

I have this simple worksheet function:

=IF(L7="OPEN",CONCATENATE(D7," ","OPEN BOOK"),D7)

How do I make the "OPEN BOOK" part in RED and BOLD?

thank you

 

[VoG]

Sorry, a formula cannot format a cell.

You could use Conditional Formatting.

 

[Andries]

Ok how do I do that?

 

[VoG]

Try like this

Excel Workbook
	D	E	F	G	H	I	J	K	L
1							Fred OPEN BOOK
2
3
4
5
6
7	Fred								OPEN
8
9
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J1	1. / Formula is =RIGHT(J1,9)="OPEN BOOK"	Abc

 

[Gerald Higgins]

But conditional formating won't make "OPEN BOOK" red and leave "FRED" black, in the text string "FRED OPEN BOOK".

 

[Andries]

But conditional formating won't make "OPEN BOOK" red and leave "FRED" black, in the text string "FRED OPEN BOOK".

Hi Gerald I like your SIGNATURE....I had a good laugh