Conditional Formatting for a cell that applies to a row

[JuliusV]

Hi All,

Is there a way where you use one cell as a status and if lets say it is Accepted, the cell turns red;however, I want the whole row to turn red too.

Currently, I can make the cell turn red, but I am not sure how to make the whole row red too.

Thanks for the help.

Best,

JuliusV

 

[NARAYANK991]

Hi Julius ,

All CF is a matter of selecting the range correctly , and using the $ symbol correctly.

If you select an entire range , say A2 : J37 , and want to use column H for checking whether its cells contain the text Accepted , then use the following CF rule :

=$H2 = "Accepted"

Before entering this rule , select the range A2 : J37.

Narayan

 

[JuliusV]

Hi,
I have been trying to do the CF as indicated above. However, I am having trouble making multiple rules work.

I provided a mock of what I was attempting.

Additional steps, in completing process could help too.

Thanks,

JuliusV

 

[Chihiro]

Hi Julias,

You had formula referencing wrong cell. Also, for it to work, don't make row absolute. IE. =$B2 and not =$B$2

 

[JuliusV]

Hi,

I tried implementing the way you stated above; however, it highlights the row above. Therefore, for customer 16, the rejected does not have any shading.

How can I fix it so that it applies to the row at hand.

Thanks,

JuliusV

 

[Chihiro]

You are referencing $B3 instead of $B2.

 

[JuliusV]

Thanks, that fixed the problem.

The last question I had is how can I copy this conditional formatting from one worksheet to another worksheet?

 

[Chihiro]

Depends on version of Excel. If you use 2013, you can just use Format Painter or paste special (Ctrl+Alt+V then t) into another workbook.

If you use 2010 or older, open both workbook in same instance of Excel and use paste special.