Making text in a cell turn BOLD upon entry of another cell

[TPD]

Hello again,

I was wondering if there was a way to make the text in a linked cell (C36)become BOLD upon the entry of either of 2 cells it is linked to in another worksheet?

heres how I would have it:
In a worksheet called "Screening Form" If either cell C22 or C23 recieves an entry,

then the text in cell C36 in the worksheet called "SDI Discovery" becomes bold.

 

[erik.van.geit]

Hi,

you can use conditional format for this
since the range is on another sheet you need to name the range
so name C22:C33 on your "Screening Form"sheet checkrange
select cell C36 on "SDI Discovery"sheet
menu format / conditional format/ formula: =COUNTA(checkrange)>0
format as required
OK

kind regards,
Erik

 

[TPD]

so name C22:C33 on your "Screening Form"sheet checkrange

Not sure what you mean by that?
How do I name cells?

I go to those two cells in the ScreeningForm and then do what with them?

Right now it's not working and in the conditional format box for cell36 simply has this in the formula option. I need to put ScreeningForm in that formula someplace don't I?
=COUNTA(C28:C29)>0

 

[dave3009]

As an alternative you could use a similar formula to your last post but put it in say Screening Form IV1 Then in IV1 in SDI Discovery have ='Screening Form'!IV1.

Then highlight the cell you want to apply format to and in conditional format use

Formula is: =$IV$1="YES"

HTH


Dave

 

[erik.van.geit]

Not sure what you mean by that?
How do I name cells?

how do you name cells
select cells C28:C29
menu insert / name / define: write checkrange
(or anything else) and use that name in the formula as written in my previous post

TIP: check out helpfiles for Name

 

[barry houdini]

Here's a way to do this directly....

use this formula in conditional formatting

=COUNTBLANK(INDIRECT("'screening form'!C22:C23"))<2

...the downside of this approach is that if you rename the worksheet it won't work unless you change the worksheet name in CF.....

 

[TPD]

Thanks Barry! Worked great!!!!!! That was whta I was looking for!

 

[Greg Truby]

Todd,

I would recommend that you still try to get Erik's to work. As Barry points out, changing the name of the worksheet will cause this conditional formula to fail. Erik's is more robust (it's also verbose, he could have simply put =COUNTA(checkrange) ). But more importantly, Named Ranges (and Named Formulae) are an amazingly powerful part of Excel and there are a number of situations where knowing how to effectively use them will allow you to solve problems much more easily. If you are going to do very much work in Excel, you definitely want to learn more about them.

Regards,