In response to
"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*"
by
loosilu
|
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...
Posted by
colin (aka colinski)
Oct 28 '21, 13:54
|
it's... ugly.. but did the trick. i had to create a table for it to work, doesn't really do it otherwise.
thank you kind indian man on youtube :)
|
Responses:
|