HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS

M

Merv

Automating the result cell to show different colors based on answer of
formula cell. I.E. D1 is result of B1/C1. D1=100% Blue fill; 90% to 99% Green
fill; less than 90% Red fill. This is a corporate dashboard.
 
S

Sean Timmons

Highlight column D.

Format/Conditional Formatting

Cell Value is: equal to: 1
Format Patterns Blue

Add

Cell Value is: greater than or equal to: .9
Format Patterns Green

Add
Cell Value is: greater than or equal to: 0
Format Patterns Red
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format cells -fill color 2
How To Have A Cell Be Blank If... 2
Can RGB fill color be automated based on 3 cell values? 2
Function for summing or counting cells based on a specified fill color 3
How to filter rows data based on background color of individual cells 3
Calculating Average based on 3 filled cells from left in a row 6
How do i auto fill cell color based on other cells' color? 1
Looking to added up based on a character from cell range 1

Top