The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 241
- Office Version
- 365
- Platform
- Windows
People,
Please lend a hand. I want B1 and then C1 to conditionally format with a green fill if they equal 90% or more of cell A1.
Looking around I thought this formula I found would (for cell B1) do it
=(B1/A1)>=0.9
But it didn't format. And I cant figure it.
As ever, thanks
<tbody>
</tbody>
Please lend a hand. I want B1 and then C1 to conditionally format with a green fill if they equal 90% or more of cell A1.
Looking around I thought this formula I found would (for cell B1) do it
=(B1/A1)>=0.9
But it didn't format. And I cant figure it.
As ever, thanks
A | B | C | |
1 | 10 | 9 | 5 |
2 |
<tbody>
</tbody>