christoforatos1968
asked on
conditional formatting in excel
For “Number of days since certification” in cell B:1, the result should be number of days since date certified (cell B:4) minus the current DATE. As each passing day, the number should increase by 1.This result should be in cell B:1.
For B5, it should be amber color, when 60 days before due date (B2). B5 should turn red when due date has expired. For B5, any other days it should be green.
Can someone give me the proper programming for the CELLS mentioned. View the attachment.
EXAMPLE.xlsx
For B5, it should be amber color, when 60 days before due date (B2). B5 should turn red when due date has expired. For B5, any other days it should be green.
Can someone give me the proper programming for the CELLS mentioned. View the attachment.
EXAMPLE.xlsx
See attached file for the result.
EXAMPLE-1--Result.xlsx
EXAMPLE-1--Result.xlsx
=B2-TODAY() is used to calculate the no of days
Based on the value in the cell, the conditional formatting is done.
Based on the value in the cell, the conditional formatting is done.
I prefer to use the function DAYS(end, start). I find it easier to read, when trying to figure out what I was trying to do.
The only gotcha in the solution is that you're allowed to apply multiple conditional formatting criteria to a single cell/range of cells.
The only gotcha in the solution is that you're allowed to apply multiple conditional formatting criteria to a single cell/range of cells.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HTH,
Dan
EXAMPLE-mod.xlsx