Hello everybody,
I want to create a conditional formatting for the following column in my stock portfolio:
I would like 2 conditional formatting (i have two of these sheets, which are identical, so one for each):
1) I would like the first formula to highlight the cells if the date entered is 1 month ago or more from the current date. I imagine some sort of =today()-30, but I tried this and it did not work
Would appreciate any help!
2) Same as 1) but when the data in the cell is = to the current data. Also highlighted with red.
Thank you everybody!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I want to create a conditional formatting for the following column in my stock portfolio:
I would like 2 conditional formatting (i have two of these sheets, which are identical, so one for each):
1) I would like the first formula to highlight the cells if the date entered is 1 month ago or more from the current date. I imagine some sort of =today()-30, but I tried this and it did not work
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
2) Same as 1) but when the data in the cell is = to the current data. Also highlighted with red.
Thank you everybody!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)