Conditional Formatting

[Closed]
Report
Posts
2
Registration date
Thursday January 9, 2014
Status
Member
Last seen
January 9, 2014
-
 Blocked Profile -
Hi,

I use excel to plot my production planning and would like to format so the ship date cell turns red once the ready date is greater then the ship date that way i can plan according and notify customers.

so in this example the first cell is D3 is the results cell and cell G3 would be the data cell that determines if the order is late.

Not sure how to do this any help would be great:

Example

Order Customer Ship Date Start Date Run Hours Ready date
21897 WIS 24-Jan 1/24/14 4:33 30.36 1/25/2014 10:55

3 replies


Liquibox,

OK, well today is (or tomorrow will BE!) your lucky day!

You have won the BEST formatted question award!

We need to know what version of Excel, if you would be so kind!

Hang tight, after we know which version, we can show you how to use the BUILT-In function of conditional formating in EXCEL! It is a tool. Are you having troubles writing the conditional formulas?
Posts
2
Registration date
Thursday January 9, 2014
Status
Member
Last seen
January 9, 2014

Microsoft Excel 2010

Ok, to build a formatting rule, select a cell like here:



Then make a selection of When to format, I have selected the First one:


Now you, write the formula, and select the Colors:


Then...you have this.....



I understand that this is very brief, and really if you look at it, it performs no real task ("oh my gosh, I waited this long for this?" Is what you are thinking!). The point of this was show how to use the conditiona formatting tool.
Just build the logic around your ship date cell!

Have fun! Post back if you still have issues!

//ark
-Moderator/Contributor