Hide Text

[yipppppppy]

I have the below table where from Columns B to X, there is conditional formatting set where it turns green if its any number entered higher than 0. If blank its red and any other value its yellow. What i want to do is hide the text whereever 1 is entered. So i want the cell to still be showing as green but when i enter the number 1, it is hidden. I dont want to hide the 0.4 and 0.3 numbers or any other number that isnt a 1.

I tried changing the colour of the font so it matches the green cell colour but it makes no difference.

What am i missing here?

Note: I am using Microsoft 365

 

[Alex Blakenburg]

In conditional formatting when =cell=1 try a custom number format of ;;;

 

[Peter_SSs]

I tried changing the colour of the font so it matches the green cell colour but it makes no difference.

Depends just what your CF rules are and what order they are in. Here I have used that idea of same green for cell fill and cell font.

23 11 18.xlsm
	B	C	D	E	F
2	1	1	L	1	1
3	1	1	L
4	1	1	L	1	1
5	1	0.4	L	0.3	222
6	1	1	L	1	1
7	1	1	SM	1	1
8	1	1	1	1	1
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F8	Expression	=AND(ISNUMBER(B2),B2>0,B2<>1)	text	NO
B2:F8	Expression	=B2=1	text	NO
B2:F8	Expression	=ISTEXT(B2)	text	NO
B2:F8	Expression	=B2=""	text	NO