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, 2023 in Others by Kithuzzz
• 38,010 points
382 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, 2023 by narikkadan
• 63,420 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
• 63,420 points
2,648 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, 2023 in Others by narikkadan
• 63,420 points
278 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

answered Jan 21, 2023 in Others by narikkadan
• 63,420 points
442 views
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, 2023 in Others by narikkadan
• 63,420 points
256 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
• 63,420 points
413 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
• 63,420 points
1,108 views
0 votes
1 answer

Conditional formatting with Index(Match), 2 conditions (vertical & horizontal)

Use FILTER to search using two or ...READ MORE

answered Jan 30, 2023 in Others by narikkadan
• 63,420 points
514 views
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
• 63,420 points
1,434 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
• 63,420 points
1,155 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