Using Excel as Database_too few parameters

[Jeyalakshmi_KS]

Hi,
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

[Nithinkrishna]

Hey @Jeyalakshmi_KS

Are you going to update format colour or a column

Thanks
#nK

[Jeyalakshmi_KS]

Trying to update format colour only

[ashwin.ashok ((TheCodingTheory))]

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