Does any one know a way in which I can make cells appear (with formulas contained within them) based on a different cells value (if it is greater than) and if the cell contains a value that is less then the defined limit than the cells just don't appear at all.
I thought I could do this by assigning a macro that activates depending on the cells value (Im not really too sure about how to do this) and would it be easiest to just record this macro or to code it myself. I was also wondering if there was a possibility of doing this using conditional formatting.
Thanks
Can you provide an example?
Take a look at using Conditional Formatting.Does any one know a way in which I can make cells appear (with formulas contained within them) based on a different cells value (if it is greater than) and if the cell contains a value that is less then the defined limit than the cells just don't appear at all.
You could set the cell font and background color to the same color, thus rendering the cell content "invisible", and then use Conditional Formatting to change either one of them to a new color.
Conditional Formatting
If you are wanting to hide cell, then that will require VBA and you will need provide the specific conditions for hiding/unhiding the cells (which means hiding entire rows or columns - not a single cell).
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks