Report

Conditional Formatting Based on Data in another Cell [Solved]

Ask a question anniedavis1980 4Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Last answered on Jul 21, 2016 03:51PM
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 
Helpful
+0
moins plus
Try this, see if it helps!
http://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color#p910487
anniedavis1980 4Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Jul 19, 2016 07:43PM
Thank you. I will try this tomight and post the results. I appreciate your feedback.
Reply
anniedavis1980 4Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Jul 21, 2016 03:48PM
Thank you so much for your direction. It works perfectly. I really appreciate you and this forum. I will definitely pay it forward.
Reply
ac3mark 6201Posts Monday June 3, 2013Registration date ModeratorStatus December 5, 2016 Last seen - Jul 21, 2016 03:51PM
You are very welcome! Thank you for the kind feedback! You can mark it solved if you want!
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!