Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to do some conditional formatting on certain lines in a spreadsheet.
Can you please advise how to do this:

Here is what it needs to do -

If Cell in this line in column C reads "in progress", make the entire line
yellow;
If Cell in this line in column C reads "overdue", make the entire line red;
If Cell in this line in column C reads "Completed", make the entire line green

Many thanks.
 
Line =- row? If so select ranges needed (click in the row headers and select
as many as you need), do format conditional formatting, select formula is

=$C1="In Progress"
click the format button,. select pattern and yellow, then click add and add
another condition, repeat but use "Overdue" and red patterns and repeat for
"Completed"

Then click OK
 
Use "Formula is", rather than "Cell value is", within conditional
formatting. If your active cell when you apply the formatting is in row 2,
use "Formula is" =$C2="Completed" noting the absolute addressing for the
column and relative addressing for the row.
 
Thank you. I understand this but can't get the entire row to turn color.
Where can I see the relative addressing for the row?
 
If you select all rows that you want to include and start with the first row
number ($C2) it will be applied to all rows you have selected
 
You need to select the whole row before you apply it, if you click on the
row header to the left you will select the entire row, then you can just
hold down the mouse button and select downwards for multiple rows
 
I have changed how we are doing this, per "the boss". We now have a separate
column for "Status". Now, I need the formula to say:

If this cell in the G column reads Completed, make the entire line green;
If this cell in the G column reads Overdue, make the entire line red;
If this cell in the G column reads In Progress, make the entire line yellow;

I know roughly how to do it but I am having trouble getting the entire line
to change color based on what is in the G cell in each line.
 
A few weeks later now and I have to modify this conditional formatting and I
can't understand how I did it. What cell do I have to be sitting on in order
to modify this formattin? Or do I have to select all the lines?
 
I should say that I am trying to add another "clause"of formatting but the
"add" is greyed out.
 
because at least through Excel 2003 only support for 3 conditionals, so
the context feature switches off the "add"
 
One way is to make one of the conditions the default for the cell.
Otherwise resorting to VBA is the only other way.
 
Back
Top