Forum Discussion
Excel Formula for Colored cells
SergeiBaklan well red equals dead jobs green equals sold jobs and peach equals jobs bid pending
Sorry, but that says me nothing. What it will be in Excel terms? For example, if cell in column C is equal to "Dead" then red, if equal to "Sold" then green, etc
SergeiBaklan wsell it would be as follows then
if cell in column F is red then equakls dead
if cell in column f is green it equals sold
if cell in column f is peach then equals bid / pending
I meant opposite - if cell value is ... then ...
You may add one more column with the status which could be selected from drop-down menu: dead, sold, pending.
Base on values in this column you may color your table using conditional formatting and make some calculations taking status values as logical test.