LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Populate cell is another cell is populated

I need to populate a cell if another cell is populated. In other words, if
A2 or B2 or C2 are not null, then put "Orange" in cell D2.

Then if Cell D2 is populated and cell E2 is not populated, then I want to
put "Please enter a color" in cell F2 and highlight cell E2 in red.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for a cell which is blank returns populated cell Gracey1 Excel Discussion (Misc queries) 1 February 2nd 07 09:17 AM
How do I hide a row in excel if a certain other cell is populated Teresa Hoffman Excel Worksheet Functions 1 October 4th 06 08:50 PM
auto populate cell based on previous cell drop down list selectio. PuzzledbyLists Excel Discussion (Misc queries) 2 September 11th 06 01:28 AM
Index heading when cell is populated Kevin M Excel Worksheet Functions 2 September 7th 06 06:00 PM
Check to see if a cell is populated bbmerc Excel Worksheet Functions 1 August 19th 05 04:15 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"