•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"
Our take
If you're aiming to enhance your "Format as Table" experience by turning negative numbers red while preserving the row colors, you've encountered a common challenge with conditional formatting. Conditional formatting often resets background colors, which can disrupt your desired aesthetic. To achieve your goal, consider using a custom formula in your conditional formatting settings that specifically targets negative values without altering the existing row colors. This approach will allow you to maintain the visual integrity of your table while clearly highlighting negative figures.
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]
Read on the original site
Open the publisher's page for the full experience
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