| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Help
I want for a cell to change color if one cell E15 has an R in it and if cell
G15 is more than 8.5 hours. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help
One way:
CF1: =AND(COUNTIF(E15,"*R*"),G15TIME(8,30,0)) Format1: <patterns/<desired color In article , mndpy wrote: I want for a cell to change color if one cell E15 has an R in it and if cell G15 is more than 8.5 hours. Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help
maybe
=and(e15="r",g158.5) or =and(e15="r",g15time(0,8,30)) It depends on how you enter that 8.5 hours -- is it a real time or just a regular old number? mndpy wrote: I want for a cell to change color if one cell E15 has an R in it and if cell G15 is more than 8.5 hours. Any help would be appreciated. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help
One more question what is the G15 is a subtraction of time however it is just
a gerneral text format? "JE McGimpsey" wrote: One way: CF1: =AND(COUNTIF(E15,"*R*"),G15TIME(8,30,0)) Format1: <patterns/<desired color In article , mndpy wrote: I want for a cell to change color if one cell E15 has an R in it and if cell G15 is more than 8.5 hours. Any help would be appreciated. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help
Thanks!
"mndpy" wrote: I want for a cell to change color if one cell E15 has an R in it and if cell G15 is more than 8.5 hours. Any help would be appreciated. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Help
Try:
=AND(COUNTIF(E15,"*R*"),TIMEVALUE(G15)TIME(8,30,0 )) In article , mndpy wrote: One more question what is the G15 is a subtraction of time however it is just a gerneral text format? "JE McGimpsey" wrote: One way: CF1: =AND(COUNTIF(E15,"*R*"),G15TIME(8,30,0)) Format1: <patterns/<desired color |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting | New Users to Excel | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
