apply conditional formatting of a cell to all coloumn

Question

I want to apply this format&nbsp;=TODAY()-$J$4&gt;300&nbsp;for the whole column without the need to repeat this formula for each cell and changing&nbsp;the cell name each time&nbsp;&nbsp;&nbsp;

subodh_tiwari_sktneer · Answer

HassanBosha&nbsp;&nbsp;Let's assume that you want to apply the conditional formatting to the range J4:J6, then select the range J4:J6 and then make a new rule for conditional formatting using the formula given below...&nbsp;=TODAY()-J4&gt;300&nbsp;Notice the J4 in the above formula which must be the first cell in the selected range J4:J6.

hassanbosha · Answer

Subodh_Tiwari_sktneer&nbsp;How about if I want to highlight the cell of the current date on the calendar in the columnand make all the above dates invisible till I show them ?other meaning the current date is highlighted at the top and above it the previous dates but invisible&nbsp;

sergeibaklan · Answer

HassanBosha&nbsp;
It depends dates are sorted or not. If sorted, two rules applied to J4:J30 or so.
=$J4=TODAY() to highlight current date
=$J4&lt;TODAY() and select same background and font colours.

hassanbosha · Answer

No, I meant the dates in column Band yes they are sorted I just want that the date of the current day to be shown at first exactly after the Date cell

subodh_tiwari_sktneer · Answer

HassanBosha&nbsp;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).&nbsp;=B5&lt;TODAY()

Forum Discussion

apply conditional formatting of a cell to all coloumn

8 Replies

Resources