Pitt_posum
New member
- Joined
- Oct 31, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi Everyone
Im having problems with the result I want with my formula.
The formula works but Im unable to copy to other cells
=IF(($I$4<>""),$I$4<0.5) Then highlight in yellow.
For example, for CELL "I5" I want the formula to show =IF(($I$5<>""),$I$5<0.5) without having to go in on every single cell and fix it.
When I merge conditional formatting, it copies exactly the same formula. Each formula should affect its own cell.
See attachment
Thanks in advance
Im having problems with the result I want with my formula.
The formula works but Im unable to copy to other cells
=IF(($I$4<>""),$I$4<0.5) Then highlight in yellow.
For example, for CELL "I5" I want the formula to show =IF(($I$5<>""),$I$5<0.5) without having to go in on every single cell and fix it.
When I merge conditional formatting, it copies exactly the same formula. Each formula should affect its own cell.
See attachment
Thanks in advance