Top cell in a list to match cells below of a certain value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need my header row (one cell) to match cells below of a certain value. I'm
currently working on a calendar and have used the conditional format "v"
which fills in the cell blue for people on vacation (gantt chart). I need the
first cell in that column (Business) to turn blue if any of the cells below
it are filled in.

Does Excel do this?
 
Select the cell to be blue, say A1, then Format>Conditional Formatting>Formula
is:

=NOT(ISBLANK($A2:$A10))

Format>Pattern to blue.


Gord Dibben MS Excel MVP
 
Unfortunately, I've already used the 'up to 3' conditional formats for other
places in the spreadsheet. Is there a way to do this same concept within the
cell?
 
Okay, so I tried putting that information into the cell and it works but
comes back with 'TRUE', as it's supposed to. Is there a way to change the
'TRUE' to something else, like a symbol or another text object?
 
Do not place the formula into the cell.

Place the formula into the dialog box at Format>CF>Formula is:


Gord
 
There are 3 conditions per cell, not 3 conditions per sheet.

You cannot write a formula in a cell to change the cell's color.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Excel Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Comparison of columns using Conditional Formatting 3
formula to enter data into a blank cell 1
Importing cells frmom a calendar workbook 4
Merged cells disturb autofilter indicator 2

Back
Top