I would like to highlight a cell red if it's value is NOT either 1 or 0. It seems this should be simple enough, but I can't quite figure it out. Any suggestions?
Thank you!
I would like to highlight a cell red if it's value is NOT either 1 or 0. It seems this should be simple enough, but I can't quite figure it out. Any suggestions?
Thank you!
cond_format6.xlsx
HI dks,
please see attached for one solution.
Regards,
jeversf
1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =AND(A1<>1,A1<>0)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks