how do i use colours with formulas in excel?
I am trying to create a spreadsheet of results using formulas and I want to
have cells highlighted depending on the outcome in different colours ie pass (green) fail (red) etc |
formatconditional formatting
-- Don Guillett SalesAid Software "RINNY" wrote in message ... I am trying to create a spreadsheet of results using formulas and I want to have cells highlighted depending on the outcome in different colours ie pass (green) fail (red) etc |
It would be best to indicate what constitutes pass or fail
but it is a simple comparison yielding True or False that Conditional Formatting uses. If True you get the conditional formatting specified. If False or an error you skip over that test and test additional C.F. if present. http://www.mvps.org/dmcritchie/excel/condfmt.htm --- 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 "RINNY" wrote in message ... I am trying to create a spreadsheet of results using formulas and I want to have cells highlighted depending on the outcome in different colours ie pass (green) fail (red) etc |
All times are GMT +1. The time now is 08:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com