CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
isaac nsiah
isaac nsiah

Reputation: 11

Excel issue with conditional formatting and rules

The database in question:

enter image description here

I am trying to create an excel database to use at work. I am having trouble with a few formulas. The dates in columns L,M,N and O are dependant on the date value entered in column H. I need each column to change colour when the date in the cell is less than or equal to todays date. This part I have managed to do. But the first issue I am having is when the next date is reached I would like the previous cell date to return to normal, So only one colour is displayed at a time. I am also having trouble getting the cells in column P to remain white/blank when cell value is blank

Upvotes: 1

Views: 34

Answers (1)

user4039065
user4039065

Reputation:

For column L it looks like you created a CFR based upon a formula like,

=and($l2<today(), $p2="")

Add another condition to the formula.

=and($l2<today(), $m2>=today()), $p2="")

For column M this becomes,

=and($m2<today(), $n2>=today()), $p2="")

... and so on.

Upvotes: 1

Related Questions