Excel - Conditional Formatting an Entire Row?

Question

I want to create a spreadsheet where if a value says Yes then the entire row is highlighted and if No then the row is left alone, is this possible?

Answer 1

yes it is...

Apply Conditional Formatting to a Row

You can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, you could colour the entire row in a table, if the values in column B are over a set value.

1. Select the cells to be formatted (A2:D4 in this example)
2. Choose Format>Conditional Formatting...

3. From the first drop-down list, choose Formula Is
4. In the text box, enter a formula that refers to the active cell in the selection.

example, the formula is: =$B2>75

Use an absolute reference to column B ($B), to ensure that the conditional formatting in all columns refers to the value in column B. Otherwise, the formula will be adjusted in each column, and won't work properly.

Answer 2

hi, Do your CF in this order, Yellow, pink then green. be certain you spotlight each and every rown you like those policies to coach to. For Yellow and pink, you will opt to apply a formula (CF > New Rule > Use a formula...) For Yellow: =AND($B1<>"Y", $A1>right this moment(), $A1"Y", $A1"") For green: =$B1="Y" once you do them, in case you bypass to regulate policies, green would be first, then pink, then Yellow. additionally, Excel might placed better citation marks in those formula, extraordinarily on the golf green formatting. in case you bypass to regulate policies, and you spot that formula study like this: "=$B1=""Y""" then eliminate all those better citation marks till it appears that evidently like it does above.