Solved conditional formula for changing value color for

May 21, 2013 at 11:28:21
Specs: Windows XP
so how is the formula written - if a cut time is 19:30 and the gate time is 22:45 the result being a late start by 3:15 how can i color code the late times red and the early or on time times green
=D3-C3+ (D3<C3),if(d3>e3), colour red,if(d3<e3), colour green

See More: conditional formula for changing value color for

Report •


#1
May 21, 2013 at 11:40:19
I don't understand what you are trying to with this formula. The syntax is incorrect and it will return an error.

=D3-C3+ (D3<C3)

As far as Conditional Formatting, the Rule (formula) is quite simple. Conditional Formatting requires a Rule that will return either TRUE or FALSE.

If you put these formulas in a cell, you will see that they will return either TRUE or FALSE based on the values in D3 and E3. Use these as the Conditional Formatting Rules and choose the appropriate color for each.

=D3>E3

=D3<=E3

The corresponding color will be assigned depending on which of the 2 rules is TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 21, 2013 at 12:02:28
here's an example of what i need assistance with its time related ... cell c3 = 19:30 (cut time), d3 = 22:45 (gate time) if d3 is greater than c3 i want that value sum to be colored in red if it's less than i want to leave it black

Report •

#3
May 21, 2013 at 12:49:15
✔ Best Answer
Please don't double post.

You do not state what cell you wish to change color,
so for this example we will use cell E3.

Conditional Formatting 2007

1) Select your cell E3
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=IF(D3>C3,TRUE,FALSE)

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color Red
9) Click OK
10) Click OK

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 21, 2013 at 13:15:08
thank you first and foremost. the values i want to auto red are those that are greater than the cut time - help pls


Report •

#5
May 21, 2013 at 14:48:51
Have you tried my suggestion?

If you want cell D3 to turn red when it is greater than C3
just select cell D3 in the example I posted.

MIKE

http://www.skeptic.com/


Report •

#6
May 21, 2013 at 15:15:19
Actually, you don't need a complete IF statement. You can simplfy it and use:

=D3>C3

Excel will return either TRUE or FALSE depending on the values in each cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question