cell color

USING EXCEL 2010 Hello, I have an excel spreadsheet and want to highlight and change the font/cell color of any changes that I make automatically. I will be sitting in a meeting making edits real-time and would like to be able to quickly show the changes without having to edit every cell...

Hello, I have some cells under conditional formatting rules to highlight it a certain color. In another worksheet, I want it to pull a particular value if that cell color is highlighted. How would I go about doing this? ~~~~~~~ =if(F5=ORANGE,"",D6) ~~~~~~~ USING EXCEL 2010

Hi. I was wondering if there's a formula I could use to format a cell's background color based on the value in a different cell? I have values in cells A2 - A200. I want the cell below the cell directly above it to change a certain color if it's value is greater than or less than the value...

I would like to understand how to make a cell (A1) turn green if i was to enter the value 'yes' into another cell (B2). I guess this is really simple and that you would use an 'If statement', however can someone please provide me with a solution. Thanks............FYI - using excel 2007.

Hi guys, Could someone suggest me a VBA macro to change the color of a cell automatically for a specific period of time -say 5 minutes, based on the value the subject cell holds at that time. The cell value is not manually entered but comes from a sub. There will be hundreds of such cells so...

Greetings Everybody :) I have a workbook in wich I consolidate 65,535 rows of data from 6 other workbooks using compound lookup. I lookup (using INDEX & MATCH) based on a double criteria. That's not the issue. The issue is that I need to grab not only the values of the matching cells, but also...

Hello, I need to verify if a cell has a specific RGB color, for example [204,255,204]. The tricky thing is that I am not allowed to use Macro, VB,... Is there a way to verify it? Theoretically i thought about some ideas: verify the color against another cell (both have the same RGB value)...

I want to click on a cell and have the color change. There is a cell range I want this to be in and not the whole work sheet. I have some code which was given to me but doesn't include a range. and I want a different color but having a hard time finding the color codes. If I could have...

Basically, I have a workbook with several sheets. Sheet 1 is a "master" sheet and it contains a ton of numeric and text values. The other sheets reference cells from this "master" sheet. This way, a change on the master sheet is reflected in all the other sheets. What I want: When a value on...

I have a subroutine that looks at 3 cells to get an R, G and B value, then fills a pre-defined range of cells with that color (using this: Private Sub Worksheet_Change(ByVal Target As Range) ' error checking here Range("C3:E5").Interior.Color = RGB([A1].Value, [B1].Value, [C1].Value) End Sub...

Is it possible to create a formula that looks at a cell (say A20) and if TRUE changes the colour of A22 to green if false to red? Long shot...