• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting in Pivot Table

P

paradise

Member
I could not able to do conditional formatting in Pivot Table by using the formula as mentioned below :

Code: 
=VLOOKUP(B6,SO!$A$1:$K$6622,11,0)="Not Approved"

Steps followed :Home >Conditional Formatting > New Rule >Use a formula to determine which cells to format

After putting formula,formatted with fill.

BUT IT DON'T WORKED OUT.

kindly let me know where I am wrong.

The same query has been posted at >
http://www.excelforum.com/showthread.php?t=1149868&p=4446239#post4446239
 

Attachments

paradise said:
I could not able to do conditional formatting in Pivot Table by using the formula as mentioned below :

Code: 
=VLOOKUP(B6,SO!$A$1:$K$6622,11,0)="Not Approved"

Steps followed :Home >Conditional Formatting > New Rule >Use a formula to determine which cells to format

After putting formula,formatted with fill.

BUT IT DON'T WORKED OUT.

kindly let me know where I am wrong.

The same query has been posted at >
http://www.excelforum.com/showthread.php?t=1149868&p=4446239#post4446239
Click to expand...

What do you want to end up with? Do you want the list on Sheet SO to highlight "Not Approved"?
 
NARAYANK991 said:
Hi ,

See your file now.

Narayan
Click to expand...
Thanx for your kind reply.

When a filter is applied and my original data is pasted then , It does not work .Can u let me know, why it has not worked ? As I have changes the range also accordingly.Pls let me know what steps did u follow.

But when I add few data and apply filter to the existing data and change the range then it works.Why copying and pasting my original data in the existing sheet(which u have given) does not work ?Pls let me know where am I wrong.
 
Last edited:
Link sent to the email id that u have sent .Kindly resolve the issue and send me in that email id which you have received thru link.
Kindly do not distribute it ,dispose it immediately.

Thanks for your consistent effort in solving my query.
 
Last edited:
You must log in or register to reply here.
Back
Top