+ Reply to Thread
Results 1 to 3 of 3

Changing text to Bold from another cell entry

  1. #1
    Registered User
    Join Date
    12-10-2003
    Posts
    41

    Changing text to Bold from another cell entry

    Hello

    I'm trying to create an effect,..but it's not working out too easily.

    I have 2 cells in a worksheet called Screening Form.
    They are C22 and C23.

    I would like it so that if "either" one has an entry...then cell AA24 reads "YES"

    THEN...

    If CellAA24 Reads YES,...then the text in
    Cell C36 in ANOTHER WORKSHEET called SDI Discovery shall turn to BOLD.

    Possible? How would I write this out?
    I'm gessing that I need 2 separate formulas for this:
    One for CellAA24 and yet another for Cell C36.

    The less complicated the better!

    Thanks!
    td
    Todd P. Dolce

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Have you tried an event macro such as worksheet_change ?

    HTH
    Cheers
    Carim

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Intersect(Target, Range("C22:C23")) Is Nothing Then
    Exit Sub
    Else
    If Target.Value <> "" Then
    Sheets("SDI Discovery").Range("C36").Font.Bold = True
    Range("AA24").Formula = "YES"
    End If
    End If
    End Sub

    HTH
    Cheers
    Carim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1