MrExcel.com - Your One Stop for Excel Tips & Solutions

formatting color

Posted by Amit on September 10, 2001 10:06 AM

hi,
Cant r'ber how to do this but would love to know how do I command/program to change the color of a cell based on its data.

For example, if the value is 1 I want it to be red and if it is 0 I would like it be yellow. PLEASE HELP.

Posted by Aladin Akyurek on September 10, 2001 10:38 AM

Format|Conditional Formatting