Conditional Formatting and CountIF Statement

[Kim]

I need to apply shading to cells that have been counted in a countif statement.

Help!

 

[Norman Harker]

Hi Kim!

It would help if you gave us the condition for the countif

But use that condition in Format > Conditional Formatting

 

[Kim]

Thanks for helping me Norman.

Here is the countif statement =COUNTIF(D3:W3,"<70%")

If a cell has been counted in this formula, I want to apply a shading as a conditional format.

Thanks again

 

[Norman Harker]

Hi Kim!

Let me just check that formula as it might be wrong.

Do you really mean:

=COUNTIF(D3:W3,"<"&70%)

Or are you wanting to check for a text entry of <70%

 

[Kim]

Yes, it is a text entry.

Hi Kim!

Let me just check that formula as it might be wrong.

Do you really mean:

=COUNTIF(D3:W3,"<"&70%)

Or are you wanting to check for a text entry of <70%


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

 

[Frank Kabel]

Hi
not sure but do you want to color the cells which CONTAIN this formula?

 

[Kim]

Hi Frank.

I need to color theh cells that are counted by the countif statement.

Thanks for helping

 

[Frank Kabel]

Hi
select your range of data, goto the condtional format dialog and enter
the condition
<0.7

 

[Norman Harker]

Hi Kim!

Are you actually getting your formula to count any text entries of
<70%