Report

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

Ask a question anniedavis1980 4Posts Tuesday July 12, 2016Registration date July 21, 2016 Last seen - Last answered on Jul 21, 2016 at 03:51 PM by ac3mark
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
plus moins
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 at 07:43 PM
Thank you. I will try this tomight and post the results. I appreciate your feedback.
anniedavis1980 4Posts 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 7596Posts Monday June 3, 2013Registration date ModeratorStatus August 18, 2017 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!

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!