Conditional formatting Rows

[HappyChappy]

Hi currently use this formula to highlight an entire row =$R3="N" and it works fine
what i'm trying to do is if any of the row contains data not just this particuler cell i want to format the line a different colour
so for agurment sake the line has data format it amber.. when the partinuler cell has "N" format line green to show its complete
any help please

 

[Special-K99]

Maybe something like
=COUNTA($A3:Z$3)<>0
Counts number of non empty cells. If it's not 0 then at least one cell on the row has data so should be formatted as amber.

 

[Marcelo Branco]

Assuming data in A3:Z3 maybe...

Rule 1 - green
=$R3="N"

Rule 2 - amber
=AND(COUNTA($A3:$Z3),$R3<>"N")

M.

 

[HappyChappy]

tried it but not working
It defaults the whole table to amber over riding the other formats.

 

[Marcelo Branco]

Try the first formula to green and do not check Stop If True
You didn't mention a rule to red - could you clarify?

M.

 

[HappyChappy]

i use same formuls for red and green turn line to colour if either Y or N is entered in coloum R.
i wanted to have lines with data in amber so it stays that way until it either is a Y or N

 

[HappyChappy]

the idea is if there is any content in the cells it makes the line amber. then once i enter a Y or N to say it completed the amber is over ridden.

Hope this makes it clearer.

 

[Marcelo Branco]

Maybe...

Top rule (green)
=$R3="N"

2nd rule (red)
=$R3= "Y"

Bottom Rule (amber)
=AND(COUNTA($A3:$Z3),$R3<>"N".$R3<>"Y")

M.

 

[HappyChappy]

The first the row are how it should look the red and green work fine but the amber doesnt work at all.

 

[Marcelo Branco]

It's hard to help without seeing your data and expected results. The picture you showed above doesn't help .
Could you, please, post a clear data sample where we can see the columns' letters and the rows' numbers?
Try XL2BB

XL2BB - Excel Range to BBCode

Convert selected range to BBCode to include as a snapshot in your question.

www.mrexcel.com

M.