Results 1 to 7 of 7

Thread: Conditional Formatting for certain cells in columns

  1. #1

    Conditional Formatting for certain cells in columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guys- I'll try my best to describe but hopefully you will better understand once you take a look at the sample workbook. Basically there are three different tables in a worksheet, with months being the column headings. The three different tables are portfolios, and the rows are the triggers (prices) where you would buy a certain volume.

    My problem is that I want when the user enters a amount for Trigger 1- it will display an XXXX (or maybe highlight the cells) for Trigger 1 in the other portfolios. Trigger 1 will not always be in Portfolio A.

    Is there a way to do this without insertting a formula into every cell for each month, maybe some conditional formatting or macro that I'm not aware of?

    Thanks for any help

    Matt
    Attached Files Attached Files

  2. #2
    i see where you have xxxxx in some cells in portfolio A . Are those supposed to be there, it is kind of confusing , according to your explanation there would only be xxxxx showing up in all other portfolios besides A

  3. #3
    See if this is what you had in mind.
    Attached Files Attached Files

  4. #4
    Quote Originally Posted by tommyt61 View Post
    See if this is what you had in mind.

    Thanks for the reply sorry in the delay getting back to you.

    That formula was closer to what I need however I get a circular reference when I try it for all the portfolios.



    Heres a new sample that might be more clear. Thanks
    Attached Files Attached Files

  5. #5
    alright i see what you are trying to do now. that will be tough, i'll see if i can come up with something.

  6. #6
    Thanks, any help would be great I actually need this for work so even if it doesn't work any progress would be great and maybe I can build on it

  7. #7
    Quote Originally Posted by MattMurdock View Post
    Thanks, any help would be great I actually need this for work so even if it doesn't work any progress would be great and maybe I can build on it
    This may not be the best approach but you said you would be happy with anything to start with and work from. The thing that is the problem here is that to do what you need to do you need to be able to enter data into a cell but at the same time have a formula in that cell to check for conditions. I just seperated the entering of the triggers into a sepereate grid . on the worksheet at the right hand side you will see a grid laid out almost like you r master grid on the left. You enter you triggers into the proper cells in the right side grid and the left side master grid automatically updates . there is conditional formatting that will error check the right side grid for you. If you enter more than say one trigger 1 on in a column it will flag red to let you know you have entered to many. It might seem a little busy at first glance but you enter the data the same as you were to start with, so it is not going to cause you any more time. I hope this will get you started, if you have ay questions let me know.

    Reminder you do not enter data into the left side area.... only enter trigger data into the right side grid.

    Note: i added a macro that will clear your trigger grid when you need to. you will see the button for under the grid.
    Attached Files Attached Files

Posting Permissions

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