I have a spread sheet with columns that have cells with formulas displaying result and section headers in text. I want to color the cells with results
greater than zero. All my attempts have failed as my format seems to be unable to distinguish between the header cells and the formulated cells thus coloring all cells. Help would be greatly appreciated.
Use the option to use a formula instead (it's the lowest in the list):
=AND(ISNUMBER(reference),reference>0)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
That colored the Heading (text) cells but not the value cells.
Here's a capture of it working on my end.
everything is red.png
excel forum snip.GIF
Here is a snip of the sheet
Can't view your capture.
Matybe start in the row below the heading?
Also, avoid using entire columns for CF ranges, it will slow your file down (I have a feeling this is what you did?)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Let's try that again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks