Entire Row should fill with Yellow color and font should be Red using conditional formatting

[vijavad]

Hi Folks,

Here is my question .

1) If i select the drop down list either Offshore Reject or Onsite Rejected or client rejected in the attached sheet in column H2 i want the entire row from A2 to H2 should be formatted with Yellow fill color and the font should be RED.
2) If i select the drop down list either Offshore Select or Onsite Select or client select in the attached sheet in column H2 i want the entire row from A2 to H2 should be formatted with green fill color and the font should be BLACK.

Can anybody help me in this .

Data Validation list is as below.

Offshore Reject

Onsite Rejected

Client Reject

Offshore Select

Onsite Select

Client select

<colgroup><col></colgroup><tbody>
</tbody>

Sl.No Source Candidate Name Mobile Number Notice Period Client interview Completion Date Comments Final Status 1 2 3 4 <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Select A2:H2 down to the last row of data
Conditional formatting > New Rule > Use a Formula > =ISNUMBER(SEARCH("Reject",$H2)) > select format > OK
And then repeat that but change the word "Reject" to "Select" for the other case.

 

[vijavad]

Hi Fluff,

Absolutely its working with your formula . But what if i need to check multiple conditions and apply colors to the rows.

Suppose my condition is to highlight the row A2:H2 to Yellow if i select from the drop down either On Hold or Reject or Position cancelled .

Do i need to use OR function ? Please help.

 

[Peter_SSs]

Do i need to use OR function ?

You certainly can use the OR function, but you don't need to as there are other options too. Here are two.

=OR($H2="On Hold",$H2="Reject",$H2="Position cancelled")

=SEARCH("|"&$H2&"|","|On Hold|Reject|Position cancelled|")