I am trying to apply a conditional format where if there is a stock item on hand in column I (i.e. value is greater than 0) and the price code hasn't been put in in column K (i.e. value is 0) then highlight cell.
I have been using this formula
=AND(I2>0,K2<=0)
but it doesn't seem to work. It is highlighting cells that don't meet this criteria and the ones where it does meet them, it is not picking it up.
Any thoughts?
Have you tried partical absoluting?
=AND($I2>0,$K2<=0)
or
=AND($I2>0,$K2<>"")
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
Gave those a try but still getting random results.SAMPLE.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks