•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Negatives in Red in a "Format as Table"
I have a document that I have used "Format as Table" so each row is a different color. I want to make it so that when a number is negative, it turns red. I thought I was able to do that with conditional formatting, but I just now realized it makes the background of all the cells white, even those in the row that is colored. Any way to fix this? I already tried formatting the cells using the number format "0.00%;[Red]-0.00%", but still having the same issue. Any ideas on how to get this to work the way I want it to? I really want don't want to have to manually format as a table (different color every other row).
Pic to help show what the issue is.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com