If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.

click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.

I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.

"Bernie R." wrote:

click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.

Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour.
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11*pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.



"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -

Pete_UK,

Why use AND rather than If?

Thank you.

"Pete_UK" wrote:

Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour.
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11 pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.



"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -

You are setting up these formulae in the Conditional Formatting panel,
where it is expecting a condition that evaluates to TRUE in order to
trigger the formatting that you set. It is slightly different than a
normal cell formula.

Try it out, and see if it does what you wanted.

Hope this helps.

Pete

On Mar 13, 1:54*pm, LiveUser
wrote:
Pete_UK,

Why use AND rather than If?

Thank you.



"Pete_UK" wrote:
Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour.
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11 pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.

"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Thanks Pete_UK.

I have been trying it out, but haven't had much luck, yet. I am sure it is
my own stupidity. Here is how I rewrote the formula because I need the
condition set for a range. When I use the range the formul does not work. I
am still getting to understand if's and and's in general.

=AND($C2:C19<"",$C$1<"",$C2:C19$C$1)

"Pete_UK" wrote:

You are setting up these formulae in the Conditional Formatting panel,
where it is expecting a condition that evaluates to TRUE in order to
trigger the formatting that you set. It is slightly different than a
normal cell formula.

Try it out, and see if it does what you wanted.

Hope this helps.

Pete

On Mar 13, 1:54 pm, LiveUser
wrote:
Pete_UK,

Why use AND rather than If?

Thank you.



"Pete_UK" wrote:
Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour.
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11 pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.

"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Don't use a range.

Put the cursor on C3 and set up the formulae as I originally gave them
to you. Then when you are happy with it working in that cell, you can
use the Format Painter icon to apply it to other cell - double-click
the icon and then just single click in the cells where you want the
format to be transfered (press <Esc once you have set it to all
cells).

Hope this helps.

Pete

On Mar 13, 2:28*pm, LiveUser
wrote:
Thanks Pete_UK.

I have been trying it out, but haven't had much luck, yet. I am sure it is
my own stupidity. Here is how I rewrote the formula because I need the
condition set for a range. When I use the range the formul does not work. I
am still getting to understand if's and and's in general.

=AND($C2:C19<"",$C$1<"",$C2:C19$C$1)



"Pete_UK" wrote:
You are setting up these formulae in the Conditional Formatting panel,
where it is expecting a condition that evaluates to TRUE in order to
trigger the formatting that you set. It is slightly different than a
normal cell formula.

Try it out, and see if it does what you wanted.

Hope this helps.

Pete

On Mar 13, 1:54 pm, LiveUser
wrote:
Pete_UK,

Why use AND rather than If?

Thank you.

"Pete_UK" wrote:
Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour..
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11 pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.

"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -