Conditional formatting - Value from a differnet cell

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
77
Office Version
  1. 365
Platform
  1. Windows
Hello All

I have a table made with tasks in it and I was hoping that excel could shade the tasks when they are ticked off (Cells H6 to H21). I have made check boxes and then put a cell link in to a different cell (G6 to G21 with a True / False value), which I will eventually hide. Can I ask how I then set a conditional format command to colour shade a different cell (H6 to H21 depending on the TRUE / FALSE value of the other cells?
 

Attachments

  • cells.jpg
    cells.jpg
    159.4 KB · Views: 3

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
2,549
Office Version
  1. 2016
Platform
  1. Windows
Hi Trevolly,

A Conditional Format is set when the result is TRUE so in this case you just need to point to the same row in G

Cell Formulas
RangeFormula
G6,G20:G21,G15:G16,G12:G13,G10G6=TRUE
G17:G19,G14,G11,G7:G9G7=FALSE
Cells with Conditional Formatting
CellConditionCell FormatStop If True
H6:H21Expression=$G6textNO
 

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
77
Office Version
  1. 365
Platform
  1. Windows
Thanks for the info and I understand the theory but I just can’t work out what the conditional format formula would be for the cells.
 

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
77
Office Version
  1. 365
Platform
  1. Windows
Thank u so much. I’m sorry I was being stupid, I was overthinking it all. Excel going round and round in my brain all day!
 

Forum statistics

Threads
1,175,517
Messages
5,897,895
Members
434,685
Latest member
asdf12l3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top