Conditional formatting - Text

mholme58

New Member
Joined
Jul 27, 2010
Messages
40
Hi All, I need to return TBC in cell D7 if B7 contains text, if not leave it blank.
I'm using Excel 2007.

Any ideas? I've tried a few things that haven't worked.

Thanks
Martin
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Try this formula in D7:

=IF(ISTEXT(B7),"TBC","")

It's not a conditional formatting formula.
 

mholme58

New Member
Joined
Jul 27, 2010
Messages
40
Cheers guys, I'd already tried that formula in conditional, doesn't work there as you said.

Thing is it's used by a group of people so once they enter details in & over write the formula I don't want to keep going in to put it back in.
Hence I was trying for a conditional formula.

Sorry needs to be conditional.

Martin
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

Sorry, you can only format a cell with conditional formatting. What version of Excel do you have?
 

mholme58

New Member
Joined
Jul 27, 2010
Messages
40
2007

May just have to have it set so if the cell is blank or states TBC then highlight it yellow.
Don't really want to do that as don't really want loads of yellow cells in rows not being used.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You could try the custom conditional formatting formula:

=ISTEXT(B7)

and the number format:

General;General;General;"TBC"

D7 would need to contain some text, even if it's only a space.
 

mholme58

New Member
Joined
Jul 27, 2010
Messages
40
Yeah just means more manual input the month after to replace any cells typed over.

Never mind, cheers for the help.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,373
Messages
5,836,875
Members
430,460
Latest member
cristian270

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top