Change cell color when numbers, dates or text are entered. How?

**n2lectual** · 03-26-2008, 05:21 PM

(1) Is there a way to change the color of a specfic cell when a number or date is entered? (text also, but not priority)

AND

(2) Is there way to change other designated cells color when entry is made into the one specific cell in the same row?

Initially I am trying to color out (maybe gray) events as they are accomplished when entered as a number (weight) or date into the proper cells and upon last date entry this would color out the whole row of anything not perviously colored out.

Thanks

**Portuga** · 03-26-2008, 05:24 PM

1 - in conditional format of the cell in the formula section (assuming a1 for example)

type in "formula" =a1<>"" and choose the colour you want

**n2lectual** · 03-26-2008, 05:51 PM

Thanks, that works for the one cell, just what I needed.

Now, can other cells in the same row be formatted to change color when this cell changes or data is entered?

Example: a1, b1, c1, d1, e1, f1, no color or white.
Enter date or number into g1 changes to gray with conditional formatting "formula" =a1<>"" .

How can I make a1:f1 also change to gray?

**Portuga** · 03-26-2008, 06:00 PM

If you want the whole row to change colour when A1 has data you can use the formula in a1

=$a$1<>""

and copy the formats of cell A1 to the whole row, everytime A1 has data, all the others will change colour, but if A1 has no data, and B1 has data for example, then B1 will stay the same.

if you want cell b1 to change either when A1 has data or when B1 has data, you can use the following in a1 and copy formats to the same cells in the row:

=OR($A$1<>"";A1<>"")

**n2lectual** · 03-27-2008, 03:36 PM

Thank you.

**Blogspot** · 05-08-2013, 07:50 AM

Does anyone know what formula to enter so that I can apply the above principle to a whole column? I want to be able to get a row to change colour when a particular cell is entered. The formula above works but I now want to know how to apply that formula to a whole column so, for e.g. when I enter text in cell A1, the whole of row A will change colour but when I enter text in cell B1, I want row B to change colour, C1 for the whole of row C etc. etc. How can I do this without having to create a new rule for each row?

**arlu1201** · 05-08-2013, 07:56 AM

Blogspot,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.