I have a coulumn of numerical data that is based on criteria from other cells. If that criteria is met then it generates the number, if it's not met then it leaves the cell blank. I need to set up a highlight rule that says that if the numerical data is over 30 then it highlights it. I tried using the built in highlight greater than value rule, which works great, but it is also highlighting those cells that are left as blank.
Use the formula option and use =AND(...)
http://www.excelforum.com/excel-form...lank-cell.html
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If it's throwing a problem with text,
Then I'd highlight based on a formula instead:
like that.
Please Login or Register to view this content.
Here is the formula that is imbedded in the cells for that column:
=IF(K10="APPROVED",L10-C10,IF(K10="REJECTED",TODAY()-C10,IF(K10="WORKING",TODAY()-C10,IF(K10="CANCELLED","",IF(K10="INITIAL REJECT","","")))))
The results that I get when the criteria is either "CANCELLED" "INITIAL REJECT" or blank results in the cell being blank. Those are the cells that are still being highlighted even though their results are not over the 30 day limit that I am targeting.
Originally Posted by ben_hensel
If it's throwing a problem with text,
Then I'd highlight based on a formula instead:
like that.Please Login or Register to view this content.
Tried that, but then it doesn't recognize any of them as numbers so it doesn't highlight any of them.
Last edited by xrajncajnx; 05-07-2014 at 11:48 AM.
Make life easier for everyone, don't just describe your worksheet, upload a sample of the workbook.
Ideally in the sample I would like to see only what is either "WORKING" or "REJECTED" and over 30 days highlighted in yellow on the "Total Days in Review" cell, but if it can only recognize all that are over 30 days that's fine as well.
As the link provided explained, use AND.
Formula:
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks