Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
Excel Problem
I have a problem as far as conditional formatting is concerned. Problem I have a spreadsheet called (Report Dates) that stores dates, it is split into 12 worksheets each corresponding to a month. In that you enter a date of when a report is sent in. for example (01/12/2003) Now I have another spreadsheet that is called (Exception reporting) with two columns one says Received the other says Not Received. What I would like to happen is as soon as a date is entered the in (Report Dates) I want the corresponding month in Exception reporting to read Received in Green. If however it is not received then I want it o read Not Received in Red. So If the correct date is entered I want the to say Received if not then I want it I sat Not received I hope that all this makes great sense I hope you can help Thanks in advance Joel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |