Excel conditional formatting
I have a table with names across the top and tasks down the side, i have set
up a drop down list for each task under each name, in the drop down is level 1, level 2 and level 3, they are formatted to change colour depending on the level, i want the cell with the persons name in to change colour when every task is at level 1 can anyone help please. Thanks |
Excel conditional formatting
Select the cell with name in it. Under format - conditional formatting,
change the first box to "Formula is" and use something like: =AND(A2="Level 1",B2="Level 1",C2="Level 1") to test if multiple other cells are all at "Level 1". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lewy" wrote: I have a table with names across the top and tasks down the side, i have set up a drop down list for each task under each name, in the drop down is level 1, level 2 and level 3, they are formatted to change colour depending on the level, i want the cell with the persons name in to change colour when every task is at level 1 can anyone help please. Thanks |
Excel conditional formatting
You are da man Luke M, Cheers mate.
"Luke M" wrote: Select the cell with name in it. Under format - conditional formatting, change the first box to "Formula is" and use something like: =AND(A2="Level 1",B2="Level 1",C2="Level 1") to test if multiple other cells are all at "Level 1". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lewy" wrote: I have a table with names across the top and tasks down the side, i have set up a drop down list for each task under each name, in the drop down is level 1, level 2 and level 3, they are formatted to change colour depending on the level, i want the cell with the persons name in to change colour when every task is at level 1 can anyone help please. Thanks |
Excel conditional formatting
=AND(A2="Level 1",B2="Level 1",C2="Level 1")
=AND(A2:C2="Level 1") =COUNTIF(A2:C2,"Level 1")=3 -- Biff Microsoft Excel MVP "Luke M" wrote in message ... Select the cell with name in it. Under format - conditional formatting, change the first box to "Formula is" and use something like: =AND(A2="Level 1",B2="Level 1",C2="Level 1") to test if multiple other cells are all at "Level 1". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lewy" wrote: I have a table with names across the top and tasks down the side, i have set up a drop down list for each task under each name, in the drop down is level 1, level 2 and level 3, they are formatted to change colour depending on the level, i want the cell with the persons name in to change colour when every task is at level 1 can anyone help please. Thanks |
All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com