•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
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#conditional formatting
#Format as Table
#negative numbers
#cell formatting
#background color
#number format
#color coding
#Excel
#row coloring
#manual formatting
#data visualization
#table design
#formatting issue
#alternating colors