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.

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.

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