Mar 13 2023 01:26 AM
Hi, i want to set to format the whole row to red colour if the status is showing 'open', and i have a list in datavalidation. I put the formula like this but the row colour does not change at all. please help
Mar 13 2023 02:14 AM
Mar 13 2023 02:21 AM
Mar 13 2023 06:17 AM
SolutionMar 13 2023 06:52 PM
Mar 15 2023 04:02 AM
@daydream1989 , you are welcome