Results 1 to 6 of 6

Conditional Formatting of Font Color based on Values in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2010
    Location
    London
    MS-Off Ver
    2007
    Posts
    49

    Question Conditional Formatting of Font Color based on Values in another cell

    Hi everyone

    I was hoping you could help me with some VB code for conditionally formatting a column of cells...

    I have attached a dummy workbook, and basically the values in column F are in white. I would like these values to turn to black font, but only after all the corresponding values in column H have been filled in (between 1-5).

    I have a macro in my actual workbook, which is why I need it as code and not a formula in the cell.

    Thanks for your help!!

    DP
    Attached Files Attached Files
    Last edited by dpcp; 01-23-2012 at 07:50 PM.

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