ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   coloring cells (https://www.excelbanter.com/excel-discussion-misc-queries/120788-coloring-cells.html)

egarcia

coloring cells
 
I have 6 different conditions on my spreadsheet I want colored. I tried
conditional formatting but it didn't work for all of them. Columns c & d have
values. The conditions are if d-c <-20 = color d light green, -20 = green, <
20 = pink, 20 =red. Also, if any cell in column d is a blank i want it gray.
Then, if any amount in column d are -20, or 20 I want c to be colored
yellow. Is it possible?
C D
2 =gray
10 20 =pink
24 60 =red, cell c = yellow
50 45 =light green
75 10 =dark green, cell c = yellow


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com