conditional formatting help please

M

Marty

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.
 
S

Stefi

Apply for A10 this formula in CF:
=AND(A6="W",A10>TIME(8,50,0))
Regards,
Stefi


„Marty†ezt írta:
 
D

Dave Peterson

Select A10
Format|Conditional formatting (xl2003 menus)

Formula is:
=and($a$6="w",$a$10>time(7,50,0))
give it a nice format.

7:50 is 7 hours, 50 minutes, right?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting in Excel 2010 2
Conditional Formatting 2
I think an easy Conditional Formatting ? 4
Conditional Formatting Minimim Value 2
Excel Conditional Formatting 1
Negative Conditional Formatting Excel 2003 2
Conditional Formatting 4
conditional formatting 1

Top