Previous Topic Next Topic

Conditional Formatting

Closed
Liquibox Posts 2 Registration date Thursday January 9, 2014 Status Member Last seen January 9, 2014 - Jan 9, 2014 at 05:20 PM
 Blocked Profile - Jan 10, 2014 at 11:06 AM
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

Answer 1 / 3
Blocked Profile
Jan 9, 2014 at 06:58 PM
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?
0
Answer 2 / 3
Liquibox Posts 2 Registration date Thursday January 9, 2014 Status Member Last seen January 9, 2014
Jan 9, 2014 at 07:04 PM
Microsoft Excel 2010
0
Answer 3 / 3
Blocked Profile
Jan 10, 2014 at 11:06 AM
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
0