/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
8/2/19
Data Validation with Conditional Formatting 0 Recommended Answers 6 Replies 368 Upvotes
1 Recommended Answer
$0 Recommended Answers
The data validation and conditional formatting rules are no longer working. Previously, when I used the data validation in the cells (in the form of a drop-down menu) cells would change colour dependent on the rules from the conditional formatting which is currently 'value is equal to'. The cells are no longer changing colour when using the drop-down menu but only when the values are equal to the number.
All Replies (6)
8/2/19
so something on the sheet has changed - can shared editable copy?
marked this as an answer
Helpful?
11/21/19
I have the same issue, data validation choice box is gone and so is conditional formatting based on those cells.
marked this as an answer
Helpful?
11/23/19
I had fetched it when I was turning off and still waiting to have the solution. Google Photos Features
marked this as an answer
Helpful?
11/23/19
Hello everyone,
 
For one of the volunteers to help you with your problem and because there are so many variables that can affect your results, would you please take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”?  Thanks!
 
Adam
marked this as an answer
Helpful?
12/17/19
Hi Jaz Nole,
 
Because this is a new question that is not related to original question, would you please create a new post in the forum and give as much detail as possible in your question.  This will help the volunteers to try and find a solution to your problem.  Thanks!
 
Adam
marked this as an answer
Helpful?
12/17/19
We already skipped this and are using Excel as it is easier with the conditional formatting.  Thanks
marked this as an answer
Helpful?
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
Questions about a different Google product are no longer considered off-topic and should be moved to the relevant community.
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/docs/profile/0?hl=en