Microsoft Office Questions? Ask a IT Expert for Support ASAP
I want Excel to highlight only those cells (not necessarily in a "block") with the format that I've caused Excel to apply via conditional formatting. The nature of the format is irrelevant.
I'm trying to select cells in List 1 that contain nuymbers equal to the cells in List 2. I'm trying to do this using conditional formatting. The format used is irrelevant.Maybe you should call me. My number is XXXXX Ext 270.
Correct. In Conditional Formats, when I click OK after selecting Same under Data Validation, Excel selects all cells in the List, not just the cells containing the selected format.
I could send you the esperimenta spreadsheet if this would help.
OK. I understand.
By "it would" do you mean that Excel would select all cells or that sending the experimental spreadsheet would help?
I tried to attach the spreadsheet to this reply, but it appears to accept only images.
Yellow fill is OK for the format.
I will need to be able to do this on any sheet I specify.
The file ID is 285830.
FYI, I have limited experience with Excel macros.
Sorry, but I can't figure out how to open the file I downloaded from Wikisend.I found some xml documents, but no Excel documents.
I tried it, and it selectes the cells you cormatted, but doesn't select the cell I selected via conditional formatting.
Also, how can I transfer the button to other spreadsheets?
I tried to upload the file, and it briefly opened the file ID enter window, then closed it and opened the download window before I could enter an ID number.
Sorry. It's on its way.
The number is XXXXX
I tried tried adding a non-conditional format to the conditional format. Neither formatted cell was selected when the putton was pushed.
The file ID number is XXXXX
=COUNTIF(List2:B2)>0 (B2 is the first cell in List1.) The formula identifies all cells in List1 that produce a TRUE result.
As I indicated above, I need to be able to apply this to any spreadsheet I select. How can I do this?