Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting a row based on a value in a cell
I apologize for how simple this question probably is. I have created a log
in Excel 2003 to track submittals we receive. These submittals are either approved, approved as noted, revised and resubmit, or rejected. I have columns set up to track the dates and names of the submittals as well as a column for each of the four possible responses. I type an "X" in the appropriate cell to designate approval status. I have been manually shading rows yellow for approved and approved as noted, blue for revised and resubmit and red for rejected and leaving them with no shading if I haven't received the submittal yet. Is it possible to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting a row based on a value in a cell
yes!
so, the assumptions: Rows start at 2 (Row 1 for headers), Date in column A, name in B, responses in C - G in A2, format - Conditional formatting Formula is: =COUNTA($C2:$D2)0 Format as yellow =COUNTA($E2:$F2)0 Format as blue =COUNTA($E2:$F2)0 Format as Red Copy and paste special/formats to the bottom right of your table. Should highlight each row accordingly. Blanks should stay white "architect laurie" wrote: I apologize for how simple this question probably is. I have created a log in Excel 2003 to track submittals we receive. These submittals are either approved, approved as noted, revised and resubmit, or rejected. I have columns set up to track the dates and names of the submittals as well as a column for each of the four possible responses. I type an "X" in the appropriate cell to designate approval status. I have been manually shading rows yellow for approved and approved as noted, blue for revised and resubmit and red for rejected and leaving them with no shading if I haven't received the submittal yet. Is it possible to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on a cell value | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting on one cell based on value in another | Excel Worksheet Functions | |||
Conditional formatting based on another cell | Excel Discussion (Misc queries) |