How can I use conditional formatting in an Excel table using structured references?
--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Luau
--
Chapters
00:00 How Can I Use Conditional Formatting In An Excel Table Using Structured References?
01:14 Accepted Answer Score 20
01:27 Answer 2 Score 0
01:56 Thank you
--
Full question
https://superuser.com/questions/1517823/...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #conditionalformatting
#avk47
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Luau
--
Chapters
00:00 How Can I Use Conditional Formatting In An Excel Table Using Structured References?
01:14 Accepted Answer Score 20
01:27 Answer 2 Score 0
01:56 Thank you
--
Full question
https://superuser.com/questions/1517823/...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #conditionalformatting
#avk47
ACCEPTED ANSWER
Score 20
Include the table name and add the @ symbol to reference row for row.
=INDIRECT("Table1[@col1]")=INDIRECT("Table1[@col2]")
ANSWER 2
Score 0
For me the following works: first cell of the column to be formatted is selected, then conditional formatting --> use a formula --> edit rule: put in table column to be formatted = column to compare to the first cell should be formatted now. Then I used format painter for the rest of the column, in your case Col2. it worked for me, hope it works for you as well. - Martijn
Disregard: After rechecking the effects, I noted the conditioning does not work.