justindaubar
New Member
- Joined
- Nov 16, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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.
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.