Forum Discussion
Conditional formatting does not work, please help
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 a...
What is your apply range. Apply range must be start from $J2.
- it works now after i use a new excel file. thanks.
