I want countif row in color yellow

[febausa]

I annex example , show row color yellow and formula use.

I want count only in column M the row (6,10,14,18) with color yellow .


Thank you for your help.

 

[Somendra Misra]

Hi,

This will require a SMALL old VBA macro function. Is this acceptable? As normal excel functions don't have this features.

Regards,

 

[Hui]

I assume the same rows wont always be yellow

What answers should be in Column M?

Why are there errors in Columns A:F?

 

[hazybuck]

I'm not clear on what you're trying to do, and it appears that your formula references an exterior table.

Are you attempting to have a specific result turn a certain color? If so, use Conditional Formatting, and do the following:
Select the range you want to 'turn yellow'
In the Home Tab, click on Conditional Formatting
New Rule
Select - Cells That Only Contain
Equal to (this would appear to be the best option from the data I see)
Click on Format - then select Fill and choose a color

Any cell that meets the criteria you outlined will turn the color you've chosen

HTH!

 

[febausa]

I assume the same rows wont always be yellow
always have the Bold black .
What answers should be in Column M?
I annex the complete example in column M.
Why are there errors in Columns A:F?
No errors in columns A: F because they are sources of information

Thank you for your help.

 

[Hui]

Febusa

You still haven't explained why the values in Column M are what they are ?

Do you only want to put values in the highlighted cells?



What are those values based on ?
Why is the 3rd Circled cell 1 but the others 0?
what range do you want to add up ?
Is that summation based on some other criteria?