I have a spreadsheet that equals another cell in a different worksheet. The cell that it is referencing is a result of a formula from two other cells. I have 57 cells from a38:a95 that if they equal 0 and I have them conditionally formatted to turn green, but I need to hide the entire row of them. If anything changes in the spreadsheet, say it would happen to turn to yellow because it now equals 1 then I would need it to not be hidden. TIA!
You can't use VBA to test for the color of a cell that is controlled by conditional formatting. If CF turned it green, the cell still doesn't register as "green" when tested. But cycling through colors would be the wrong way to do it anyway.
You already have the answer:
So there's your test... you can use cycle through the rows and hide the ones that equal 0 in that particular column.if they equal 0 and I have them conditionally formatted to turn green
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
So I can't create a code if the cell equals 0. How do I write that code. I am very new to codes and it is very confusing to me. Thanks!
Your question has already been answered here - http://www.excelforum.com/excel-prog...-not-used.html so marking this thread as closed.Originally Posted by Triscia
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks