Only use conditional formatting if text is present in another cell

E

Eric Livesay

Board Regular
Joined
Feb 13, 2008
Messages
127
Thanks in advance for any help from the board!

I have a sheet that tracks wether a tasks in a column have been completed or not by a drop down menu with "Yes" or "No" as the options. If "No" then the cell turns red, if "Yes" or blank it stays un-filled; that parts easy.

What i can't figure out is the column for the date of completion; I can get the cells to format to a specific color based on the date range i want but i can't figure out how to keep the cell un-filled if there is no date at all.

I would like to be able to only conditionally format a cell (A2) if the name cell (A1) has a name in it, if not the cell remains unformatted.

Is this possible?


Eric
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Select A2, go to Conditional Formatting. In the first box, change "cell value is" to "formula is". In the second box type =A1<>"". Select your format.

Remember that if you have more than one condition that they work in order, so make sure you order them correctly.
 
Upvote 0
When i select "New Rule" under conditional formatting there are several choices at the top of the "New Formatting Rule" window.

Do i select "Format only cells that contain" or "Use a formulae to determine which cells to format"?

Either way there is no box to change from "cell value is" to "formula is"

I'm using excel 2007 by the way.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Combining Yes/No Option Buttons with Conditional Formatting
Replies
2
Views
229
DavidWF
D
B
  • Question
Conditional Formatting for multiple cells based on other cell value
Replies
4
Views
293
Benong
B
J
  • Question
Conditional formatting based on value of another cell
Replies
3
Views
239
etaf
etaf
SimonHughes
  • Solved
Conditional format row if time is present in one cell
Replies
3
Views
174
Joe4
Joe4
X
  • Question
How remove date formatting but keep same numerals in order yyyymmdd
Replies
3
Views
547
Scott Huish
Scott Huish

Forum statistics

Threads
1,214,978
Messages
6,122,549
Members
449,089
Latest member
davidcom

Share this page

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
Back
Top