ST Alpha - "Excel help.. I've got list items on another tab with colored backgrounds. I'd like those items to retain the cell color when I select. " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 153

Excel help.. I've got list items on another tab with colored backgrounds. I'd like those items to retain the cell color when I select.

Posted by colin (aka colinski) Oct 28 '21, 13:37

tried this method, it did not work....

https://www.exceltip.com/tips/create-drop-down-list-in-excel-with-color.html (www.exceltip.com)

Responses:

You might have to write a series of if/then formulas. I don't think you can bring the formatting to a new cell (let alone worksheet). -- nm* - loosilu Oct 28, 13:47 3
- apparently there is a "Highlight Cells Rule" that you can set to the value of the cell. Have to do it for each list item in the table, then drag... - colin Oct 28, 13:54 2
  - Edited oh wait, I think that has been there for awhile. It works with numbers, don't think it works with text. I've used it a lot -- (edited) - loosilu Oct 28, 13:54 1
    - i can set to equals whatever word i'm trying to highlight and it seems okay with it -- nm - colin Oct 28, 13:56
Paste with formatting -- nm - con_carne Oct 28, 13:44

Post a message top

Replies are disabled on threads older than 7 days.