Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) |