Conditional formatting a range of cells


G

Guest

Is it possible to conditional format (CF) a range of cells eg A1 to A50
depending on the contents of the cells B1 to B50?
I want the individual cells in A1 to A50 to change when a value is eneterd
into the individual cells B1 to B2, eg if I enter a date in B1 then contents
of A1 changes to red, if I enter a date in B2 then contents of A2 changes to
red etc etc.

I know how to get it to change to red but it seems I have to CF each cell
individually. ie A1 to B1, A2 to B2 etc etc.

I have tried to copy and paste (format) cell A1 to cells A2 to A50 but these
would always refernce back to B1 (Because A1 refers to B1)
 
Ad

Advertisements

R

RagDyer

Select A1 to A50, with the focus of the selection in A1 (A1 is white).

Then,
<Format. <Conditional Format>
Change "Cell Value Is" to "Formula Is",
And enter this :

=B1>0

Then click on "Format", and choose whatever you like.
Then <OK> out.
And you're done!
 
G

Guest

Thanks - Exactly what i was after!!

RagDyer said:
Select A1 to A50, with the focus of the selection in A1 (A1 is white).

Then,
<Format. <Conditional Format>
Change "Cell Value Is" to "Formula Is",
And enter this :

=B1>0

Then click on "Format", and choose whatever you like.
Then <OK> out.
And you're done!
 
Ad

Advertisements


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