Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
color
the thing is and that is my question when i have a starting time lets say in
cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
color
Try looking at Conditional Formatting (Format-Conditional Format)
I think you want a formula that looks like =AND(B2<TIMEVALUE("0:30"),B2TIMEVALUE("0:01")) click the format button, choose a red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teenbeat" wrote: the thing is and that is my question when i have a starting time lets say in cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
color
UNFORTUNALY,
it didnt work, cause it has to be colored when the first time cel and the second time shell time is less then 30 min that the color has to change if its higer then 30 min then you have this formula =$B1-$A1TIMEVALUE("0:30") then when time is more then 30 min it changes color. and when lower then : =$B1-$A1<TIMEVALUE("0:30") but problem is this also changes color if start and endtime is zero (0:00). when both times are zero then there must not be color changing "Luke M" wrote: Try looking at Conditional Formatting (Format-Conditional Format) I think you want a formula that looks like =AND(B2<TIMEVALUE("0:30"),B2TIMEVALUE("0:01")) click the format button, choose a red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teenbeat" wrote: the thing is and that is my question when i have a starting time lets say in cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
color
but a part is correct i found the code
=ALS($F7-$E7<TIJDWAARDE("0:30");$F7-$E7TIJDWAARDE("0:01")) =IF($F7-$E7<TIMEVALUE("0:30");$F7-$E7TIMEVALUE("0:01")) you wher close Luke M thanx "Luke M" wrote: Try looking at Conditional Formatting (Format-Conditional Format) I think you want a formula that looks like =AND(B2<TIMEVALUE("0:30"),B2TIMEVALUE("0:01")) click the format button, choose a red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teenbeat" wrote: the thing is and that is my question when i have a starting time lets say in cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |