LinkBack URL
About LinkBacks
Hi, I am trying to get some conditional formatting to work.
I have created a very small sample, (attached), with some note within.
Let me know if there are questions.
Thanking you!
Hi, I am trying to get some conditional formatting to work.
I have created a very small sample, (attached), with some note within.
Let me know if there are questions.
Thanking you!
Please explain what the problem is with the DV you have currently. It appears to be working fine.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
Yes the DV works but I can't get any conditional formatting to work.
As per the notes included in the sheet,"I want conditional formatting to alert if the selection in coloumn C "Colour" is not from the
"Sub Category" selected in column B. And like wise Column B "Sub Category from column A "Category".
I have done this previously, but not using indirect. And my data tables are set up a bit different this time".
There is no conditional formatting in Sheet1 columns B:C as I cannot work out how to this time with INDIRECT being used.
This formatting would highlight a cell in B or C if someone goes back and changes what is in Column A or B.
Because if you change what's in column A for instance you have to manually update both columns B:C it won't happen automatically, thus the conditional formatting
to let you know there is a mismatch.
Cheers,
Ken.
Is this for an event where someone might go back and CHANGE entries? Because I can't see the need otherwise. Please confirm.
OK - let's try this.
CF for B2:
=AND(B2<>"",COUNTIF(INDIRECT(A2),B2)=0)
Applies to: =$B$2:$C$5
Yes, Exactly.
See post #5.
You could also add an explanatory alert to an adjacent column (e.g. column E).
In E2 copied down:
=IFERROR(IF(COUNTIF(INDIRECT(A2),B2)=0,"SubCategory option not available - please choose again",IF(COUNTIF(INDIRECT(B2),C2)=0,"Colour option not available - please choose again","")),"")
Thanks for the rep.
Thanks, I'll do that. Have a great day!Originally Posted by AliGW
Last edited by AliGW; 09-10-2024 at 02:18 AM. Reason: Please limit quoting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks