Forum Discussion
apply conditional formatting of a cell to all coloumn
I want to apply this format =TODAY()-$J$4>300 for the whole column without the need to repeat this formula for each cell and changing the cell name each time
To do that, assuming your dates start from cell B5 then select the date range and make a new rule for conditional formatting using the formula given below and click on Format on the conditional formatting window, go to the Number Tab and then to Custom and set the number format as ;;; (three semi-colons).
=B5<TODAY()
Okay nearly what i'm trying to do
I'm trying to make the current date at the top followed by the upcoming days
also trying to make it easy to expand all of the whole rows easily like toggling
Like one click it expands so I can get the whole column all things are visible
another click makes the rows invisible until the row of the current date