Conditional formatting question

[websterja1983]

Good morning everyone,

I am having a bit of trouble with my task for this spreadsheet. I will be as specific as possible.

I need cells A2:I2 to be shaded yellow if cell C2=1 AND cell C3 does not equal 5. If I can get something like this to work then I can figure out the rest of the sheet. Thanks for any help you can offer!

-J

 

[Gerald Higgins]

In Excel 2003, Select the Formula Is option

=and(C2=1,C3<>5)

You might need to add $ symbols for absolute references.

 

[websterja1983]

Perfect, that works. Now part two that my boss just asked my about. I have it sorted by colors (yellow, orange, green, red), now can I sort that further by date? Column A has all dates, I tried custom sort by color, then date but it gets the colors out of order. Again I appreciate the help!

-J

 

[websterja1983]

Nevermind, just figured it out.