Forum Discussion

haniizz's avatar
haniizz
Icon for Helper II rankHelper II
1 year ago

conditional color change

Hello community, from this data  Product code Product Usage TRN001 Smart TV Yes TRN002 Bicycle No TRN003 Mobile No TRN004 AC No TRN005 washing machine Yes TRN006 h...
Need Help
haniizz's avatar
haniizz
Icon for Helper II rankHelper II
1 year ago

this solution didn't work actually 

here is what I get
"The value for 'Usage' cannot be determined. Either the column doesn't exist, or there is no current row for this column"

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

see attached.  You can change the conditional formatting to whatever you like.