Forum Discussion
Solved
conditional formatting with formula
I have a conditional format set up that if D5=TRUE to highlight cells B18:D20 yellow. Now I want to be able to have those cell to NOT be highlighted when text is entered into them. So basically, IF D5=True, turn cells yellow, then if data is entered, turn off highlight. Is this possible as a conditional format, or do I need to utilize another method?
Texas_Technician Check these links:
- Complete basic operations using SharePoint REST endpoints
- Work with lists and list items
- Work with folders and files
- REST API reference and samples - I think this is what you need. From this link, you can find more documentations in left navigation:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
3 Replies
Hello kdwork,
Something like this should work:
In cell B18, create the conditional formula:
=B18<>""
Format this to no highlight, applies to =$B$18:$D$20, check the box under "Stop If True"
In cell B18, create the conditional formula:
=$D$5=TRUE
Format this to highlight yellow, applies to =$B$18:$D$20, do not check the box under "Stop If True"
Finally, make sure the format with no highlight is above the format with highlight yellow.
Hope this helps!
PReagan
