Need help conditional formatting a date column!
Hi, So i've had a look through previous threads & not managed to find the answer. I'm trying to get it so anything @now- 2years turns the cell background red, but anything less than 2 years ago turns it green. This is what i have so far - turns the +2yrs red, but everything else is just a different shade of red... Any help greatly appreciated! Thank you!! { "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField >= @now + 2592000000 || @currentField <= @now - 62208000000,'red', '#ffa59b')" } }
Count coloured cells based on conditional formatting
Can someone help me please? I am trying to get my spreadsheet to count cells based on their colour after they have been conditionally formatted. I have read various threads on here and made some progress thanks to Jamil I have put a VDA in as per advice elsewhere. However, it is clear that I am making mistakes somewhere. I have attached my file. The formula is put in next to the red cell on the analysis tab. Any help greatly appreciated.