cell color
is it possible to auto change cell color depending whether there is a yes or
no in the cell...i want to make the cell turn red when i enter yes cheers Keith |
read about Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm =LEFT(A1)="y" or if spelled out =A1="yes" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "kd" wrote in message ... is it possible to auto change cell color depending whether there is a yes or no in the cell...i want to make the cell turn red when i enter yes cheers Keith |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com