Conditional format

  • Thread starter Thread starter Flub
  • Start date Start date
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
 
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
 
Back
Top