Using Excel as Database_too few parameters

I am trying to use Excel as Database and wrote a non query to update color in excel. I am getting error as too few parameters. pasting the screenshots here

Please note that I have tried other options such as adding β€˜&’ before and after argument value

1 Like

Hey @Jeyalakshmi_KS

Are you going to update format colour or a column


Trying to update format colour only

Hi @Jeyalakshmi_KS ,

I haven’t used DB for coloring, but could you give this a try?
UpdateCellColorConditionally.xaml (11.5 KB)

ColorMe.xlsx (7.8 KB)

Kind Regards,
Ashwin A.K