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.

[TABLE="width: 167"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: left"]Offshore Reject[/TD]
[/TR]
[TR]
[TD="align: left"]Onsite Rejected[/TD]
[/TR]
[TR]
[TD="align: left"]Client Reject[/TD]
[/TR]
[TR]
[TD="align: left"]Offshore Select[/TD]
[/TR]
[TR]
[TD="align: left"]Onsite Select[/TD]
[/TR]
[TR]
[TD="align: left"]Client select[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 975"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 1119"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sl.No[/TD]
[TD]Source[/TD]
[TD]Candidate Name[/TD]
[TD]Mobile Number [/TD]
[TD="align: left"]Notice Period[/TD]
[TD]Client interview Completion Date[/TD]
[TD]Comments[/TD]
[TD]Final Status[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: left"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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|")