<div>
Use the following formulas:<br />
<br />
=$U1=&quot;U&quot;<br />
<br />
and<br />
<br />
=$U1=&quot;F&quot;<br />
<br />
To add conditional formatting to a cell select the cell you want to format. Choose the menu Format-&gt;Conditional Formatting... Change the dropdown from “Cell Value Is” to “Formula Is” and enter the above formula. Click Format and then the Pattern tab. Choose a color. Click OK and OK again.<br />
<br />
Kevin
</div>


Use the following formulas:

=$U1="U"

and

=$U1="F"

To add conditional formatting to a cell select the cell you want to format. Choose the menu Format->Conditional Formatting... Change the dropdown from “Cell Value Is” to “Formula Is” and enter the above formula. Click Format and then the Pattern tab. Choose a color. Click OK and OK again.

Kevin

<div>
You can add multiple conditions for the same cell by clicking the Add&gt;&gt; button in the conditional format dialog. Each condition can have a unique color.<br />
<br />
Kevin
</div>


You can add multiple conditions for the same cell by clicking the Add>> button in the conditional format dialog. Each condition can have a unique color.

Kevin

<div>
Sorry, missread the columns:<br />
<br />
=$G1=&quot;U&quot;<br />
<br />
and<br />
<br />
=$G1=&quot;F&quot;<br />
<br />
Kevin
</div>


Sorry, missread the columns:

=$G1="U"

and

=$G1="F"

Kevin

<div>
Kevin,<br />
Where do i add this formula?<br />
and can i change the fillcolor of entire row,not only the G1 cell?<br />

</div>


Kevin,
Where do i add this formula?
and can i change the fillcolor of entire row,not only the G1 cell?


<div>
thanks for the answer Kevin<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi guys,<br />
I want to change the fill color of a row based on the value of one of the cells in that row.<br />
I have colums from A to G. the G column is my Status column, and it can get values of U, F or null<br />
<br />
I want to change the fill color of the rows from A to G based on the above U and F values.<br />
lets say blue if it is U and yellow if it is F.<br />
<br />
can this be done using conditonal formatting? or it requires a macro?<br />
<br />
thanks
</div>
</div>


Hi guys,
I want to change the fill color of a row based on the value of one of the cells in that row.
I have colums from A to G. the G column is my Status column, and it can get values of U, F or null

I want to change the fill color of the rows from A to G based on the above U and F values.
lets say blue if it is U and yellow if it is F.

can this be done using conditonal formatting? or it requires a macro?

thanks

Conditional formatting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.