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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,303
Messages
5,600,857
Members
414,407
Latest member
Zaner0445

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