Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there any Formula for..........
I have crated a Project Track table.. Across the row i manually enter if the
item has passed "P" or Failed "F" in the table...at the end of each row i am counting the total number of iems passed by the "countif" function...I would like to know if there is any function....which can fill color in the cells that are failed...so that i can track them easily and fix the issue quickly.....I would be thankful if you can help me in this |
#2
|
|||
|
|||
Take a look at Format|conditional formatting.
John wrote: I have crated a Project Track table.. Across the row i manually enter if the item has passed "P" or Failed "F" in the table...at the end of each row i am counting the total number of iems passed by the "countif" function...I would like to know if there is any function....which can fill color in the cells that are failed...so that i can track them easily and fix the issue quickly.....I would be thankful if you can help me in this -- Dave Peterson |
#3
|
|||
|
|||
You can apply conditional formatting to do this: in cell B1, for
instance, click Format Conditional Formatting; set condition 1 to Formula Is and enter =$A$1="F" in the formula box; then choose the color you want to show for failed entries. |
#4
|
|||
|
|||
That works...I didnt know this cool feature....Thanks Dave Peterson and Dave O
"Dave O" wrote: You can apply conditional formatting to do this: in cell B1, for instance, click Format Conditional Formatting; set condition 1 to Formula Is and enter =$A$1="F" in the formula box; then choose the color you want to show for failed entries. |
#5
|
|||
|
|||
Go to Format-Style-Modify- and pick your font style
"John" wrote: I have crated a Project Track table.. Across the row i manually enter if the item has passed "P" or Failed "F" in the table...at the end of each row i am counting the total number of iems passed by the "countif" function...I would like to know if there is any function....which can fill color in the cells that are failed...so that i can track them easily and fix the issue quickly.....I would be thankful if you can help me in this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |