Conditional Formatting Based on Data in another Cell [Solved/Closed]

anniedavis1980 4 Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Jul 19, 2016 at 12:29 PM - Latest reply: ac3mark 9881 Posts Monday June 3, 2013Registration dateModeratorStatus July 12, 2018 Last seen
- Jul 21, 2016 at 03:51 PM
Hello,
I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all change to black or all change to white.

I'm trying to change the background field color of cells in a column based on a value in a different field.
A number of students will visit my facility and need to assigned specific jobs based on that number. The number of students will be entered in a field that is merged (B6,C6,D6). If there are 53 students, I need fields in Column E with a value of <54 to change to "no background fill color." (All fields currently have black fill color with an number from 1 - 136 in each field); If there are 58 students, I need fields in Column E with a value of <59 to change to "no highlight." {THis allows student names to be entered.}

The conditions will continue through 136 students (max) in which all fields in Column E with a value of 1 - 136 (or <137) should change to "no background fill color."

Thank you in advance for any suggestions. I'm so thankful for this forum to share ideas.
See more 

4 replies

ac3mark 9881 Posts Monday June 3, 2013Registration dateModeratorStatus July 12, 2018 Last seen - Jul 19, 2016 at 06:33 PM
anniedavis1980 4 Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Jul 19, 2016 at 07:43 PM
Thank you. I will try this tomight and post the results. I appreciate your feedback.
anniedavis1980 4 Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Jul 21, 2016 at 03:48 PM
Thank you so much for your direction. It works perfectly. I really appreciate you and this forum. I will definitely pay it forward.
ac3mark 9881 Posts Monday June 3, 2013Registration dateModeratorStatus July 12, 2018 Last seen - Jul 21, 2016 at 03:51 PM
You are very welcome! Thank you for the kind feedback! You can mark it solved if you want!