Thanks, got it to work. On 2026-09-13 20:43, Wade Smart wrote:
You can right click on the cell and use conditional formatting. I have one that Cell Value + Is Less Than - style Red and Cell Value + Is Greater Than - style Blue On Sunday 13 September 2026 07:19:44 PM (-05:00), James wrote:Is there a way to set the background colour of sa cell in an if statement? I want to have something like =IF(B35=100%,greenbackground,redbackground)
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy