I am trying to use conditional formating that will highlight any cell in the range M2:P9 are greater than 0 AND where M1:P1 (text) does NOT equal Q2:Q9 (text). Thanks for any help i can get!
I am trying to use conditional formating that will highlight any cell in the range M2:P9 are greater than 0 AND where M1:P1 (text) does NOT equal Q2:Q9 (text). Thanks for any help i can get!
Hi and welcome to the forum
Your ranges in your post do not match the ranges in the workbook?
You will need to adjust these ranges, but try this...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(A2>0,A$1<>$E2) Format fill as required
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
Thank you FDibbins, i feel im on the right track (and your right about my reference, i copied from my main file to a new file so i didnt have to upload the entire document). The only problem is in my Example A2 and A5 are being triggered for the conditional formating even tho A1= the Value in column E
NEVERMIND, I had a typo in my statement. Thanks again!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks