Conditional Format

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

If a2=Jan followed by b2=316 (green text, this cell already has set
conditional formats). How would I make a2 show the same colour as b2. I
have tried the conditonal format in a2 (Formula is: $h$2<1200) without
success. any ideas?
 
It must work if you apply the same formula for both A2 and B2. If CF formula
already set for B2 is =$H$2<1200 then select range A2:B2 and apply this
formula, for me it worked! (Didn't you forget to place = before the formula?)

Regards,
Stefi
 
Dave said:
If a2=Jan followed by b2=316 (green text, this cell already has
set conditional formats). How would I make a2 show the same
colour as b2. I have tried the conditonal format in a2 (Formula
is: $h$2<1200) without success. any ideas?
Click to expand...

How many times are you going to post the exact same question?
 

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

Excel Conditional Formatting 1
Conditional Formatting Formula 6
Conditional Formatting with if statement 1
Copying conditional formating 2
Excel conditional formatting with Weeknum 4
conditional formatting dependent of preceding cell 1
conditional formatting, when select a cell. 1
Conditional Formatting Applying Rule to Entire Column 2

Back
Top