Conditional Formatting (Excel 2007) Format Row Color Based on X

A

Alice M.

I have a row with data spanning 6 columns. Each Col is formatted differently
(some as date, text, or numbers.)

How do I change the entire row to a color if the entry in Col A (formatted
as text) is equal to X? (If I try to copy Col A’s format across the row, it
changes the formatting in the other Cols all to text.)

Thx,
 
D

David Biddulph

Select your range of cells, Format/ CF/ Formula Is:
=$A1="X"

Note the absolute reference for the column.
 
A

Alice M.

Thx, but doesn't work or I'm still doing something wrong . Need my row all
one color, only IF Col A="X"
 
S

Sheeloo

David had provided the solution to you...

Are you selecting the whole range?

Try once more
Select A1:F100
Choose CF
Choose Formula is
Type =$A1="X"
Choose Formatting

This will color the row, upto Col F, if that row has X in Col A
 
A

Alice M.

Yes, thx. My screens in Exl 2007 are a little bit diff than his solution for
Exl 2003, but now have it working. Great job, and my sincerest thanks.
 

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

Top