Changing cell color with either conditional formatting or macro
Closed
bealerusa
Posts
5
Registration date
Friday February 27, 2015
Status
Member
Last seen
March 3, 2015
-
Feb 27, 2015 at 11:56 AM
bealerusa Posts 5 Registration date Friday February 27, 2015 Status Member Last seen March 3, 2015 - Mar 3, 2015 at 10:57 AM
bealerusa Posts 5 Registration date Friday February 27, 2015 Status Member Last seen March 3, 2015 - Mar 3, 2015 at 10:57 AM
Related:
- Changing cell color with either conditional formatting or macro
- Notepad++ change background color - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Sound card color code - Guide
- Powertoys color picker download - Download - Other
- Html text color - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 27, 2015 at 04:11 PM
Feb 27, 2015 at 04:11 PM
Make a list of all the valid values in say, column N:
LOOKUP
MR
SP
BA
.
.
SC
EU
etc.
Then in conditional formatting:
Choose "Use a formula..."
=MATCH($E2,$N$2:$N$51,0)
Where Column E contains the value you are matching against.
Apply the formatting/color to the range of data say:
=$A$2:$H$200
LOOKUP
MR
SP
BA
.
.
SC
EU
etc.
Then in conditional formatting:
Choose "Use a formula..."
=MATCH($E2,$N$2:$N$51,0)
Where Column E contains the value you are matching against.
Apply the formatting/color to the range of data say:
=$A$2:$H$200
Mar 2, 2015 at 08:37 AM
Mar 2, 2015 at 11:22 AM
Mar 2, 2015 at 10:54 PM
and post the link to it here.
Curious though, did you try my suggestion?
If so, did it work?
Can you give more details on what you think needs to be done once you upload the file.
Mar 3, 2015 at 09:34 AM
Mar 3, 2015 at 10:57 AM
http://speedy.sh/QVBYp/raw-file-for-conditional-format-3.3.15.xls
I created a minimal Lookup list in N as you suggested. I then applied a Conditional Format to E. At this point, it appears to only be picking up the value in N6 and ignoring N2-N5. It formats the requested cells as expected. However, if you change the value in N2 to "YB CG" it then formats the entire rows of 24,26,29,35,45. And, if you change the value in the CF formula reference to something else (say, E3) the results are unexpected.
Don't really know where I took a wrong turn. Thanks for all your help! -C-