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

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

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

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses