IF conditions can or cannot be cross-formatted?

[Por2gal]

Hello, I am trying to create a cell to add 'no' automatically from non-blank cell. but i also want to add 'yes' without upsetting the 'no' condition. I have started with a IF(ISBLANK) but if i put a yes instead into the same cell[in red], i loose the original condition of the 'no' if blank. Yes is only provided as an add-on as required. If I am incorrect with the IF(BLANK) function, I would be grateful for a solution. PLease Help me find a working formula.

[Pete_UK]

A cell can contain a formula or a value - it cannot contain both. If you type Yes into the cell it will overwrite the formula.

You can amend your formula like this:

=IF(ISBLANK(C4),"",IF(R4="","no","yes"))

so that you use a different cell to indicate Yes (e.g. in column R). Copy the formula down then put anything in R6 (like "x") to see the effect.

Hope this helps.

Pete

[Por2gal]

Thank you for your quick reply Pete_UK, essentially I have formatted any 'yes' that shows in cell D4 to turn red. I have also conditioned cell C4 to turn red if no text is in cell D4. If I was to put text into cell C4, cell D4 would automatically state 'no'. I have copied the formula as have shown, however it will not keep the formula true if I type 'yes' into D4. should I be using another function to perform this difficult task?