Conditional formatting checking different cells wich equal FALSE

[dragondrago]

Hi,

I have column B with this formula: =IF(C3=A3; 1; "0"). Cells format is Custom "Yes"; "Yes"; "No". When C3=A3, I have value "Yes" and after conditional formatting cell becomes green. If i have FALSE, cell contains #N/A and warning "A value is not availableto the formula or function" (not sure if it is important).
I have column G which contains different numbers >=0.

I want to highlight cells in column G which are greater then 0 and if cell in same row in column B is 0/FALSE/#N/A

I tryed these formulas in conditional formatting:

=AND(G2>0; B2="0"/B2=""/B2="No"/B2="N/A"/B2="#N/A"/B2="FALSE" (all variants))
=IF(G2>0; IF (B2<>1 (different varinats too); 1; 0); 0)

In one of variants (not sure already in which one) I managed to highlight G2>0 and B2 containing text/=1 but I don want this.

 

[magpie2000k]

sorry I feel I am miss reading this but do you mean =IF(C3=A3, 1, 0)

When the two cells match I have yes and when they dont I have no

What is the data in your columns is it numbers or words.

 

[magpie2000k]

I then have conditional fomatting using

Format cells that contain
Choose specific text containing 0 fill red
and 1 fill green as they are what is acutally in the cell.

Hope that helps

 

[magpie2000k]

Sorry missread post thought you wanted coinditional formatting in B

In G use
=AND($B$3=0,$G$3>0)

As the formula above should only produce 1 or 0 (yes or No) in B not false or #

hope that helps

 

[dragondrago]

Sorry missread post thought you wanted coinditional formatting in B

In G use
=AND($B$3=0,$G$3>0)

As the formula above should only produce 1 or 0 (yes or No) in B not false or #

hope that helps

I want formatting in column G. Column A and C contains text (A is text and C is formula which output same text in A in certain conditions). I think that formula for formatting in column G must not include $ in front of row and column because it must compare values for every row (G2>0 and B2=0, G3>0 and B3=0 etc.). I try formula above but it still didnt work. Your logic seems good but in 1st post I write that I already try it (I see that I dont post variant without quotes but I try it too).

 

[magpie2000k]

Ok the issue I think will be in the text in cell C do you have the forumla in cell c

Also in your initial post you put =IF(C3=A3; 1; "0") ie with ; not ,

 

[dragondrago]

I have formula in C but later I need values in G and B, so main reason is how to check what is value in column B. How Excel treat this "0".

 

[magpie2000k]

Even if you format the cell as Yes no the cell is still 0 or 1 with the formula. the exmples I have given you work I have created it., the only issue I cant replicate is the conditional formatting of G because I do not know what is in C

I have just text in C so it is easy but without knowing what is in C I cannot help

 

[dragondrago]

=VLOOKUP(A2;'accepting unit'!A:A;1;0) this is formula in column C (cell C2).

 

[magpie2000k]

think you will need an expert I cant work it out from that good luck