Previous Topic Next Topic

Conditional formatting

Solved/Closed
sandy - Apr 29, 2010 at 08:39 AM
 sandy - Apr 30, 2010 at 01:04 AM
can any one help me i have following situation and i drag the formula down , i do not want to show the result in c2 because there are no data in it(blank cells), i do not want to show "no veriance " with blank cell, i have used excel if fuction

a1 b1 c1
10 100 variance =if(a1=ba,"no veriance","veriance")
blank cell blank cell no veriance
blank cell blank cell no veriance
blank cell blank cell no veriance
blank cell blank cell no veriance
blank cell blank cell no veriance

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 29, 2010 at 08:46 AM
Try this

this is for if both should not be blank 
=IF(AND(A1="", B1=""), "", if(a1=b1,"no veriance","veriance") )
0
Answer 2 / 2
sandy
Apr 30, 2010 at 01:04 AM
resolved my querry
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses