ST Alpha - "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*" (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

In response to "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. " by colin

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*

Posted by loosilu (aka loosilu2) Oct 28 '21, 13:47

(No message)

Responses:

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

Post a message top

Replies are disabled on threads older than 7 days.