Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
?
Lv 7
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 if cell = 0, set the whole row as bkg green?
Update 2:
(and font clõlor = white)
1 Answer
Relevance
- ?Lv 73 years agoFavourite 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
Still have questions? Get answers by asking now.