Forum Discussion
CONDITIONAL FORMATTING USING IF FORMULA
I am wanting to issue a conditional format for a cell to change from either positive or negative based on whether or not another cell is blank. I was able to come up with a formula that yielded the r...
Hi
If I understand properly, You need a conditional formatting in Column D (or maybe C) that popsup if the Value i is Negative: If so:
Select the cells in Column D (or C depending on where you want the formatting)
Click on the down arrow of Conditional Formatting >> Highlight Cell Rule >> Less than >> Type 0
Select the Format from the drop list (or custom format)
On the other hand, Your IF function can be more simple, as follows:
=IF(B4="",-C4,C4)
Hope that helps
Nabil Mourad