Using Conditional formatting and IF THEN Statement

I am trying to use conditional formatting to display text in a cell if specific text is in a cell on the same row
Example:

B11 is where I want the formula to insert Install if cell I11 contains Install and do nothing if it does not contain that text.
I also want this to work with the following rows futher down the sheet.
So B12 would look at I12, etc, etc.

I can use the formula

Formula:

Please Login or Register  to view this content.

The rest of the cells down Column B I am entering text into them manually.

Problem:
This formula works only if I paste it into the cell itself.
IE: It does not seem to work in the Conditional Formatting Rules Manager.

Is there a limitation for this function?

conditional formatting only changes
the format of the cell
based on if a condition is true

it will not change the contents of the cell

the formula needs to be in the cell itself and then copied down

i dont see a conditional formatting requirement in what you have said

Is there a limitation for this function?

Well, yes, the clue is in the name of the functionality; Conditional Formatting. It doesn't have the capability to insert text, only modify formatting.


Regards, TMS

A formula cannot change the contents of another cell, only the value in the cell in which it resides.

To change one cell based on another cell, you'd need VBA. Specifically, a Worksheet Change event handler monitoring the cell(s) that change.

Regards, TMS

=IF( C2="Scheduled", A1, "" )

put in B2

Ah, looks like I misread/misunderstood your question


Regards, TMS

Ah, OK. It can be done with VBA which is built into Excel.

and you cant put a formula into B11 at all - is that correct

Can I ask why?

Please Login or Register  to view this content.

Regards, TMS

No. Right click on the tab where the data is. Select View Code. Copy and Paste the code there.

Then change I11.

Regards, TMS

I don't know about the SQL part but the code was specifically designed NOT to handle multiple changes.

I'll see about changing that. No guarantees though.

Please Login or Register  to view this content.