I want to apply conditional formatting using table reference syntax. Is that feasible?
So the formula below would result in the cell highlighting if the current row's column 1 held a value of zero.
![]()
=Table1[[#This Row],[Column1]]=1
I want to apply conditional formatting using table reference syntax. Is that feasible?
So the formula below would result in the cell highlighting if the current row's column 1 held a value of zero.
![]()
=Table1[[#This Row],[Column1]]=1
Within Conditional formatting, just select the entire table and Use Formula
=$A2=1 (assuming A2 is the first cell selected in your table. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes sir, I understand how to use it in general. However, on a particular spreadsheet I have a number of complicated CFs and am debating whether to create named ranges to make them more clear. However, if table naming syntax works, there wont be a need to create the range names.
See?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks