[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Excel Conditional Formating

In a spread sheet I am working with I have two columns; names and positions.  The first contains the name of an individual filling the position in the second column.  If the first column is "NOT FILLED" I have already formatted its fill to be grey.  I want to format the position associated with the at cell to be the same fill color.
Is conditional formatting the solutions and if so how would I do that?
Thanks in advance...
Marvin
0
mabarnes11
Asked:
mabarnes11
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
If you want column B to be formatted when A is "not filled" just select column B and use this formula in conditional formatting

=$A1="Not filled"

apply grey formatting

If you want to do both columns with the single condition just change the "applies to" range to include column A

regards, barry
0
 
mabarnes11Author Commented:
Thanks Barry.  My problem is I cannot get to any window that allow me to put in your suggestion.
0
 
mabarnes11Author Commented:
Thanks Barry for a speedy and accurate reply.
0
 
barry houdiniCommented:
Which version of Excel are you using? Assuming Excel 2007 or later follow these steps:

Select column B

On "Home" tab select "conditional formatting" in the middle of the "ribbon"and then "New Rule" and "Use a formula to determine which cells to format"

Type or paste my suggested formula in the box and then choose the required formatting

Click OK and you're done.....

regards, barry
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now