If cell is marked as done, color both cells

**kakaNit** · 09-11-2023, 06:04 AM

Hi,

Under the 'Follow-up needed' section, I've set it to turn red in the cell if you write 'Yes' because it's obviously not done (simple conditional formatting). But when you've completed the follow-up and thus mark the follow-up as complete (in cell H4), I want both 'Follow-up needed' and 'Follow-up done' to turn green.
Sk?rmbild 2023-09-11.png

Is there any way to do this? My first thought was to use the GET.CELL-function to retrieve the cell color in F4 and then use this information with a IF-OR formula. The problem is that the GET.CELL-function doesn't seem to exist in the Swedish language version of Excel. Is there any other way around this?

Here's the sample file: Example.xlsx

**AliGW** · 09-11-2023, 06:08 AM

New rule for F4:

=AND($F4="Yes",$H4="Yes")

Applies to: =$F$4,$H$4

**etaf** · 09-11-2023, 06:12 AM

change you existing condition to
=AND($F4="yes",$H4<>"complete")

then you can have green as a 2nd conditional format

=$H4="complete"

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
F4 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
==AND($F4="yes",$H4<>"complete")

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

then a new rule

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
F4 and H4 using the control key for non contiguous - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$H4="complete"

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

**AliGW** · 09-11-2023, 07:38 AM

Seen, but no response ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

**kakaNit** · 09-12-2023, 12:08 PM

Thanks to both of you!

**etaf** · 09-12-2023, 12:09 PM

you are welcome

If cell is marked as done, color both cells

LinkBack

Thread Tools

Rate This Thread

Display

If cell is marked as done, color both cells

Re: If cell is marked as done, color both cells

Re: If cell is marked as done, color both cells

Re: If cell is marked as done, color both cells

Re: If cell is marked as done, color both cells

Re: If cell is marked as done, color both cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help making marked cell stay put while i sort list taking info from marked cells.

[SOLVED] Solver error:Perhaps some cells that are not variable cells are marked as Integer, Binary

[SOLVED] How to count expired cells but only if they aren't marked with YES in another cell

How to Calculate cells Only if another cell is Marked with the Letter "N"

Email a range of cells in outlook if a cell is marked with x

How to delete all background color and frame borders from cells in marked rectangle?

Mark all cells on the same rows as another marked cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions