Conditional formating with If statements

Closed

Christy - Nov 9, 2015 at 04:50 PM
Blocked Profile - Nov 10, 2015 at 04:34 PM

I want to do conditional formatting. But my numbers change if a certain box is checked..... how do I accomplish this???

i.e. A regular clean would be 30 min less green 30:01-45:00 yellow 45:01 and up = Red
But if it's a stat or ISO clean then those take longer, 0-45:00 green 45:01-60:00 yellow 60:00 & up Red So i have a drop down box for STAT that has a yes or no -

Conditional formating with If statements
How many if statements can you nest - Guide
If then statements in excel - Guide
Apply conditional formatting to the selected cells ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text - Excel Forum
Remove false from if statement ✓ - Office Software Forum

2 responses

Answer 1 / 2

Blocked Profile
Nov 9, 2015 at 04:57 PM

OK< so what part are you stuck with: the conditional formatting, or the if statement? They are both the same thing. Make a formula and attach a format to it. Can you get the cell to turn one color yet?

Christy
Nov 9, 2015 at 05:04 PM

I think all of it - I have it set up as a conditional format now with the "normal times" how to i add the IF statements to that.

I wish i could show you my sheet....

Time Requested Room # BedBoard STAT ISO Housekeeper Start Time Finish Time Total Clean Time Response Time Total Turn Time
12:35 4214 y Yes No jane 12:38 13:45 1:07 0:03 1:10
20:15 10147 April O'Neal 21:00 21:42 0:42 0:45 1:27
0:00 0:00 0:00
0:00 0:00 0:00
0:00 0:00 0:00

Answer 2 / 2

Blocked Profile
Nov 9, 2015 at 05:44 PM

OK, you have a nice start! The if statement is part of the formula to format, so with that being said, you just need to format the calculations of the worked time?

Christy
Nov 10, 2015 at 10:01 AM

The times are calculated, and that is what i want to make icon sets for, but the parameters for the icon sets will depends on if the stat/Iso cell being a yes or no.

Blocked Profile
Nov 10, 2015 at 04:34 PM

the if format is as follows =IF(logic_test,true,false).

So =if(a1>42,"YES","NO) would apply here. This would check cell a1, and if it were greater than 42, then it displays a yes.

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Excel - IF function with multiple words

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!