Conditional format

F

Flub

Hi All,
I have two columns A and B formatted as Text and H:mm respectively
each containing approx 150 entries.What I would like to do is this.
If Cell B1 exceeds a set amount the text in A1 changes colour to red,
Cell B2 And A2 etc is there an easy way to accomplish this using
conditional formatting,(been at it for a couple of hours and still
scratching my head).
Thanks for any and all help
Regards
Glenn
 
E

Earl Kiosterud

Glenn,

Select column A. The active (white) cell should be A2 for the following
formula. Format - Conditional Formatting - Formula:

=B2 > Someamount

Earl Kiosterud
mvpearl omitthisword at verizon period net
 

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 Formula 3
Conditional Formatting help (2003) 1
CONDITIONAL FORMATTING IN EXCEL 2010 1
conditional formatting update issue 5
Conditional Formatting Driving Me Crazy 2
Perplexed by simple Icon Set Cond. Formatting Issue 0
Conditional Formatting 2
Change the colour of a cell if another named cell is blank 2

Top