Conditional format based on external cell value

0 votes

want to format a row based on the contents of a single cell. I.e., if the answer to Q6 is "yes," I would like to turn row 6 green. have experimented with numerous

=INDIRECT(ADDRESS(ROW(),17))>0

and

=INDIRECT(ADDRESS(ROW(),17))="yes"
Feb 16 in Others by Kithuzzz
• 34,760 points
61 views

1 answer to this question.

0 votes

Use a rule with the formula =$Q6="Yes" and apply it to all the rows in question, starting with row 6.

enter image description here

answered Feb 16 by narikkadan
• 59,740 points

Related Questions In Others

0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 59,740 points
512 views
0 votes
1 answer

Trying to run different macros based on value of cell in a range

This demonstrates one approach to loop through ...READ MORE

answered Jan 19 in Others by narikkadan
• 59,740 points
69 views
0 votes
1 answer
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

answered Jan 23 in Others by narikkadan
• 59,740 points
61 views
0 votes
1 answer

Conditional Formatting (IF not empty)

 Use Conditional formatting with the option "Formula ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 59,740 points
94 views
0 votes
1 answer

Format an Excel Sheet in Python

The below code will help you refer ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 59,740 points
407 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 59,740 points
634 views
0 votes
1 answer

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 59,740 points
276 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP