#1
|
|||
|
|||
Populate D1 if A4 is yellow
In the attached sample I want to populate cell D1 with the number 1 if cell A4 is yellow.
Is this possible without VBA? thanks for looking at my problem! |
#2
|
||||
|
||||
I'm afraid there is no non VBA solution for this question. You will need a UDF
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
you can try conditional formatting,it will get what you want
|
#4
|
|||
|
|||
it's not work , I thought you want fill cell A4 yellow ,if cell D1 is number 1
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Red/Yellow/Green as Summary Level | USTSUser | Project | 1 | 08-12-2014 01:05 PM |
Remove yellow highlightning in a protected document ? | spookiepower | Word | 3 | 01-30-2014 03:34 PM |
Yellow background now appears behind text in newsletter. | deanna | Word | 1 | 01-30-2013 10:30 AM |
Copy Row based on yellow highlighting. | imogul | Excel | 2 | 09-28-2011 04:11 AM |
Text Highlighting in Yellow ??? | mark4man | Publisher | 0 | 12-15-2005 06:46 PM |