| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Give a value to the color of a cell
Hi, I am trying to use a conditional to get a value from another cell. i.e.
A1 background color is yellow. in B1 I would write something like if(A1=yellow,1,0) to get a value 1 in the cell B1, or 2 for blue, etc... Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i give differect color for validation list? | Excel Discussion (Misc queries) | |||
| how give excel cell red color if value above range? | Excel Discussion (Misc queries) | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| How to give function by cell color to sum two value in Excel | Excel Worksheet Functions | |||
| formula from multiple worksheets to give a color output to one wo. | Excel Worksheet Functions | |||
Threaded Mode
