I used the code as you explained with slight modification as below: case when `pos_target_date` <= CURDATE() then 'color red' end Then, I was able to see the option in Color rules as well, but I don't see any rows that meets the criteria being highlited :(

Thanks for the solution Shummer. In fact, I want to highlight the entire row (7-8 columns) based on the "date" column value for that row. So if there are 100 records and 10 of them have a date field which is less than or equal to today, I want to highlight those 10 rows. Thanks

Thank you Valiant!! That helps.