| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help please
How can I add conditional formatting in a cell that is dependant on another
cell. Example, If a letter W is entered into cell A6 then cell A10 will automatically shade in if the entered value in this cell (A10) exceeds 7:50. If any other letter is entered into cell A6 this rule will not apply. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting help please
Apply for A10 this formula in CF:
=AND(A6="W",A10TIME(8,50,0)) Regards, Stefi €˛Marty€¯ ezt Ć*rta: How can I add conditional formatting in a cell that is dependant on another cell. Example, If a letter W is entered into cell A6 then cell A10 will automatically shade in if the entered value in this cell (A10) exceeds 7:50. If any other letter is entered into cell A6 this rule will not apply. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting help please
Select A10
Format|Conditional formatting (xl2003 menus) Formula is: =and($a$6="w",$a$10time(7,50,0)) give it a nice format. 7:50 is 7 hours, 50 minutes, right? Marty wrote: How can I add conditional formatting in a cell that is dependant on another cell. Example, If a letter W is entered into cell A6 then cell A10 will automatically shade in if the entered value in this cell (A10) exceeds 7:50. If any other letter is entered into cell A6 this rule will not apply. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional formatting OR | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
