Excel: How to enter a formula such as: = if (sum(a+b-c)) <0 set txt color white, set bkg red, ELSE set... black and white?
Update:
(and font clõlor = white)
More Questions From This User See All
(and font clõlor = white)
Copyright © 2024 QUIZLS.COM - All rights reserved.
Answers & Comments
Verified answer
use conditional formatting, Home | Conditional formatting (styles) |
Highlight whole row;
New rule: Use a formula to determine which cells to format
=$a$1=0
format: Fill | green colour
Select $A$1
New rule: Format only cells that contain
Cell Value | less then | 0
format: Font | Color | White; Fill | red colour