Font Color to match other cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have condintional formatting for cell J1. If cell value J1 <-0.1 font is
green. If cell value J1 between 0.1 and -0.3 font is orange. If cell value
J1 <-0.3 font is red. Through J10.

Now I need Cell B1 through B10 to match in color with J1 through J10. My
issue is that there is a calculation already done in B1 through B10. I can't
do a Conditional Formatting and If J1 is orange then B1 orange. Or If J10 is
red the B10 is red.
 
Select B1:B10.
Format->Conditional Formatting

Condition1: Formula is
=OFFSET($B1,0,8) < -0.1

Condition2: Formula is
=IF(OFFSET($B1,0,8) >= -0.3, IF(OFFSET($B1,0,8) <= 0.1, TRUE, FALSE), FALSE)

Condition3: Formula is
=OFFSET($B1,0,8) < -0.3
 

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

counting spercific charaters in selected cells 4
Conditional Formatting Range 2
How to set cell value to emptry if three other columns are empty too 1
Pivot Conditional Formatting 4
Conditional Formatting macro: simple, but doesn't work 6
Testing Range to see if value in another Range 3
Blinking cell if value is... 6
Conditional Formating Issue 1

Back
Top