Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Colorization Based on Dates Entered

I need to colorize column B based on the dates that are entered.  Assistance is greatly appreciated.
Tasks1.3.xlsx
0
rtod2
Asked:
rtod2
  • 2
1 Solution
 
TinTombStoneCommented:
Use conditional formatting Tasks1.3.xlsx
0
 
rtod2Author Commented:
Outstanding!  Thank you.
Conditional formatting is clearly the best option here.  

How do I get the orange color to match better?  I was using a colorization tool to find a number but it appears you can't just put in a single number for the color very easily.
0
 
TinTombStoneCommented:
When you apply each conditional format, choose: Custom Format, Fill, More Colours

You can then pick standard colours or enter RGB/HSL values
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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