Conditional formatting with text

[justindaubar]

This is what I want to do:
Test a cell (e.g., A69) to be between -0.5 and +0.5.
If TRUE, then "format" a different cell (e.g., B86) with the text "No Change" with a light green fill and also a light green fill in another cell (e.g., C43).
If FALSE, then format the original cell (A69) with it's calculated value and a red fill.

When that is all working, I want to "copy" those formatting rules to other cells on the same worksheet.
Please help.

 

[6StringJazzer]

You have to do more than one thing to get all this to happen.

Put this formula in B86:
=IF(ABS(A69)<=0.5,"No Change","Something else")

Select B86 and C43 at the same time and add this conditional formatting rule:
=ABS($A$69)<=0.5
Set format to light green fill

Select A69 and add this conditional formatting rule:
=ABS(A69)>0.5
Set format to red fill

If you want to be able to copy this formatting to other cells you will have to be much more specific about the relationships among the cells in terms of their positions on the sheet. They are all in different rows and different columns. How do you determine which cell B86 needs to look at to assess its value?