How do you fill a cell with color based on a condition?

[Kanak_Lata_Singh]

Hi @Ranjit_Mhetre

Please refer below threads , hope it helps .

Fill excel cell color according to condition

Hello! Please tell me how to paint the cells in green, provided that the word “update” appears. At the moment, the program adds excel files from the directory to the database and looks for the word “update”. How to implement the selection in green, provided that we do not know in advance the range in which it is necessary to paint over. [tsgyytt] Fill colour.xaml (9.3 KB) sample 1.xlsx (8.0 KB) sample 2.xlsx (8.0 KB)

To set color to a specific cell in excel based on condition

Hi All, Am trying to match the values from Sheet1 and Sheet2, if the Sheet1 values in all columns matching with Sheet2 have to insert a new column named ‘status’ in Sheet1 and update as ‘Match’ with green color. If any value in the particular column is not matching, that needs to be marked with ‘yellow’ color and ‘status’ value should be updated as ‘NoMatch’ with Red color. Have attached the sample excel. Please assist with above workflow or sample, i tried few types, however am able to matc…