[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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
0
christoforatos1968
Asked:
christoforatos1968
  • 2
  • 2
1 Solution
 
Dan CraciunIT ConsultantCommented:
See attachment.

HTH,
Dan
EXAMPLE-mod.xlsx
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
See attached file for the result.
EXAMPLE-1--Result.xlsx
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
=B2-TODAY()  is used to calculate the no of days
Based on the value in the cell, the conditional formatting is done.
0
 
Dan CraciunIT ConsultantCommented:
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.
0
 
Naresh PatelTraderCommented:
Hi

See attached I had use =DATEDIF(date1,date2,interval) formula,
 For color formatting I had use conditional formatting Tab  - Home - Style - Conditional formatting - Highlight cell rules - greater then 60 then Green fill
formatting - Highlight cell rules - Less     then 61 then yellow fill
formatting - Highlight cell rules - Less     then  1 then  Red    fill

Thank You
Formatting.xlsx
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now