Conditional formatting
Solved/Closed
Related:
- Conditional formatting
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 29, 2010 at 08:46 AM
Apr 29, 2010 at 08:46 AM
Try this
this is for if both should not be blank
this is for if both should not be blank
=IF(AND(A1="", B1=""), "", if(a1=b1,"no veriance","veriance") )