LinkBack URL
About LinkBacks
How do I write a bar chart which reads the format of a cell instead of the content? ie I want to count how many cells in each column are amber. Amber cells have already been decided by conditional formatting.
See demo attached.
How do I write a bar chart which reads the format of a cell instead of the content? ie I want to count how many cells in each column are amber. Amber cells have already been decided by conditional formatting.
See demo attached.
use the same CF rules to count number of cells.
Your example does not include the CF you mention
That's only representative of what I have filled in. Here's it organised conditionally if it helps.
I don't know how to do that; hence I request some assistance.use the same CF rules to count number of cells.
use the following formula to calculate values in row 22.
=COUNTBLANK(B2:B19)
It's not clear from your example whether row 1 should be include or excluded from the count.
That works for blanks but there's a lot of different reasons the cell could be orange. Is it possible for a formula to read the colour of another cell this way?
You need to apply exactly the same tests to the cells that you use for CF, as I said previously. You can then deduct that value from total number of cells to get bar value.
If you don't know the CF that was applied they you can, in newer excel versions, use the DisplayFormat to determine cells fill colour as result of CF. To do this you would need to use VBA
Please Login or Register to view this content.
Thanks. I've adapted it to the real life document.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks