Formating cell

[cloudbunny]

Hi, is it possible to format a certain cell as blank? For example , I want the Somewhat Agree to become blank when i use the COUNTA function.

 

[jasonb75]

You can use conditional formatting to change the font (text) colour to match the fill (background) colour but whatever is in the cell will still be counted.

Perhaps it would be better to use COUNTIF instead if COUNTA?

=COUNTIF(A2:A200,"<>Somewhat Agree")

 

[Joe4]

I am not what you mean when you say that you "want it to become blank when you use the COUNTA function".

Note that you can use Conditional Formatting to "hide" the entry, by making the font text white if the cell is equal to "Somewhat Agree".
Then it wll blend in with the cell background color and not be visible in the cell, unless you select that cell.

 

[cloudbunny]

You can use conditional formatting to change the font (text) colour to match the fill (background) colour but whatever is in the cell will still be counted.

Perhaps it would be better to use COUNTIF instead if COUNTA?

=COUNTIF(A2:A200,"<>Somewhat Agree")

I agree with you but the question in my assignment asked to use COUNTA so i'm very confused Thanks btw!

 

[jasonb75]

the question in my assignment

Without seeing the full question, we could spend all day guessing wrong ideas.

 

[cloudbunny]

Someone has any idea how to solve this

 

[Fluff]

@cloudbunny
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).

I have merged both threads.

 

[Fluff]

@cloudbunny
As I have merged both threads, do you still want this left open?

 

[cloudbunny]

@cloudbunny
As I have merged both threads, do you still want this left open

@cloudbunny
As I have merged both threads, do you still want this left open?

no

 

[Fluff]

Ok, thread closed