Forum Discussion
Multiple Conditional Formatting
I need to figure out how to do a conditional formatting with color fill and add text. Ex.
If the formula in cell B5 gets deleted then I need the cell to turn blue and the cell to say "No Formula" is this possible? If so how do I do it?
2 Replies
If the task is to check if in some cell formula was changed on value, when better to use conditional formatting rule with the formula
=ISFORMULA(B1)-1Hi
You are combining 2 different functionalities:
- Changing the color of the cell based on whether it has contents or no >> This is Conditional formatting
- Delivering a string of text >> This is a conditional IF function and should be created in a different cell other than the one you are evaluating.
I attached a sample file with the functionalities
Check it in Excel
In column B there is a conditional formatting that changes the cell color to blue if contents are deleted
In column C there is an IF function that returns the text "No Content" if the cell to it's left is blank.
Both functionalities are triggered by deleting any cell content in column B
Hope that Helps
Nabil Mourad
