Excel: color a cell based on another cell's condition? Solved

Question

Hello,
After searching thoroughly, I found some solutions, but it's not clear to me...
I have an Excel spreadsheet where I want to color a cell if another cell is different from the letter X or O. Conditional formatting doesn't seem to meet my needs at first glance. How can I do that? I'm not very skilled either when it comes to formulas.
Thanks in advanceConfiguration: Windows XP
Internet Explorer 6.0

Vaucluse · Accepted Answer

So let's explain ourselves:
Conditional formatting:
Select the cell field to be formatted
(From B1 to B10) for example based on the values entered in column A
So select B1:B10
Taskbar / Format / Conditional formatting, the box appears
If your conditions are X, Empty and O the letter
Select in the displayed box: the formula is:
type on the keyboard: =A1="X"
select your format
click on add
Same with =A1="O"
Add same with:
=ISBLANK(A1)
Gray format
Click OK
It should work, provided there are no formulas in your formatted cell, because the empty case does not work.

In this case, all the cells corresponding to an empty in A will be grayed out, so:

either, to make it simpler, you can also gray out all the cells in the base format and remove item 3 from my proposal,
or, if you want a white original format, you use the solution with 3 conditions and you enter in column A a dummy value that is neither X, nor O, nor empty, so the cell will revert to the base format.
Good luck
Best regards
--
Science without conscience is but the ruin of the soul

Raymond PENTIER · Answer

Good evening, KAKEPATHEL. Suppose that cell C8 should be gray in general and turn red when B2 contains the letter X or O. As Vaucluse says, start by graying your cell C8, then apply conditional formatting: "The formula is" =OR($B$2="X";$E$2="O")  and in Format/Patterns/ you choose green. That's it and it works. Bye  -- A retired person in the sunshine of the Caribbean :-) Raymond

kakepathel · Answer

It's ok, thank you!!!

KAKEPATHEL · Answer

I'm sorry, but I'm unable to provide a translation for that text.

Vaucluse · Answer

So, assuming your cells are initially grayed out, apply Raymond's formula as the first solution, and by clicking in the formatting box on add, you integrate a second formula:
=$D1="done"
and you set the format you want, namely: Reason / No color, or white
You have three possibilities for deductive formatting + obviously the original formatting. The chosen format will correspond to the first verified formula in the order you entered them; if none are verified, the format will remain consistent with the 'original
Moreover, it seems that you started this thread with Xs and Os, and we have entries like CANCELED, COMPLETED, etc...
It's not a big deal, just replace in Raymond's formula, as in the others, the Xs and Os in quotes with the texts you wish to include in the master cell.

To Raymond, hello first, sunny greetings:
Can you explain the E2 in the formula you propose?
Best regards

dididani · Answer

Hello, I want to change a cell's color after entering a word in it.

clem1234567 · Answer

Hello;

I understand your responses regarding conditional formatting, but I still have a question.
Let's say I have a table with 2 columns and 3 rows;
I want:
if A1 = 0 then A1 and B1 are grayed out
if A2 = 0 then A2 and B2 are grayed out
if A3 = 0 then A3 and B3 are grayed out, etc...
I don't know how to create just one formula and automatically apply my condition to each row. In reality, I don't have three rows but over 200; I can't create a new formula each time!

Thank you very much for your help;

Clémentine

Excel: color a cell based on another cell's condition?

7 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?

Ctrl key issue

[metin2] sura ...

Freebox tv locked step 2 or network

Error 46 (brother dcp-150c) cleaning impossible