Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More Conditional Formatting
I have 5 cells. 2 of the cells are Yes/No (A8:B8). The other 3 contain
dates (W8:Y8). If the two Yes/No cells say 'Yes', then my conditional formatting formula can stay the way it is, which is '=COUNTIF($W8:$Y8,"0")=3'. However, if one of the two Yes/No cells says 'No' then I only need two of the three date cells to have a date. So, if A8="no", then only W8,Y8 need to be "0" for my row to be highlighted. And, if B8="no", then only W8,X8 need to be "0" for my row to be highlighted. P.S.-A8 and B8 would never both be "no". Would I need to add more formatting conditions, or is this just a whole different type of formula altogether? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More Conditional Formatting
Select row 8 and try this CF formula:
=OR(AND($A8="No",$W80,$Y80),AND($B8="No",$W80,$ X80)) Regards, Stefi tvh ezt *rta: I have 5 cells. 2 of the cells are Yes/No (A8:B8). The other 3 contain dates (W8:Y8). If the two Yes/No cells say 'Yes', then my conditional formatting formula can stay the way it is, which is '=COUNTIF($W8:$Y8,"0")=3'. However, if one of the two Yes/No cells says 'No' then I only need two of the three date cells to have a date. So, if A8="no", then only W8,Y8 need to be "0" for my row to be highlighted. And, if B8="no", then only W8,X8 need to be "0" for my row to be highlighted. P.S.-A8 and B8 would never both be "no". Would I need to add more formatting conditions, or is this just a whole different type of formula altogether? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |