Conditional formatting - Fill colour and dates

[JTBS]

First post here. Here goes:

I'm trying to reduce the amount of data I enter manually in an excel Parts List at work. I don't really have a clue how to code but what I'm trying to do in Excel might sound something like this in computer language (see attachment):

If Cell B3 & D3 = fill colour green then>
Value in Cell C3=Value in B3
and
D3=Todays Date (i.e. date I'm actually filling in the info)

Alternatively if I enter a date in D3 (any date, could be 04/04/1916)

If D3 = date entered then>
C3 & D3 = Fill Colour Green
and
Value in B3 = Value in C3.

Is it possible to do this in Conditional Formatting?

[sktneer]

Hi,
Welcome to the forum.

Please follow these steps....

1) Select the range C3:D7

2) Home Tab --> Conditional Formatting --> New Rule --> Select a rule type "Use a formula to determine which cells to format" --> In the formula box type the formula given below and click on Format to set the format of your choice --> OK --> OK

Please Login or Register  to view this content.

[FDibbins]

JTBS welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

[JTBS]

Hi,
Welcome to the forum.

Please follow these steps....

1) Select the range C3:D7

2) Home Tab --> Conditional Formatting --> New Rule --> Select a rule type "Use a formula to determine which cells to format" --> In the formula box type the formula given below and click on Format to set the format of your choice --> OK --> OK

Please Login or Register  to view this content.

Hi,

I've followed the steps and tried the code you posted but I'm not getting anything. Could you have a look at the attachment and see if I'm doing something wrong?

Cheers.

[sktneer]

Refer to the attached.

[JTBS]

Refer to the attached.

Am I right in saying this code (=AND($B3=$C3,ISNUMBER($D3)) requires me to enter quantity delivered and date?

Is it possible to just enter the date and then the value in cell B3 will appear in C3 and also cause C3 and D3 to have fill colour green.

Alternatively could I just enter the quantity delivered which would cause the date to appear in D3 and C3 & D3 to have fill colour green.

[sktneer]

Your description is a bit confusing.

If you want the column D to populate automatically with the current date once you input the quantity received in col. C, that can be achieved with a VBA code.
In the attached macro enabled file, once you input e.g. quantity received in C3, the current date in D3 will be populated automatically and C3 and D3 will be highlighted as per the conditional formatting rules.

Since this is a macro enabled file, you will need to enable the macro when prompted.

[JTBS]

Your description is a bit confusing.

If you want the column D to populate automatically with the current date once you input the quantity received in col. C, that can be achieved with a VBA code.
In the attached macro enabled file, once you input e.g. quantity received in C3, the current date in D3 will be populated automatically and C3 and D3 will be highlighted as per the conditional formatting rules.

Since this is a macro enabled file, you will need to enable the macro when prompted.

Apologies, I guess I'm not good at explaining this sort of stuff. That's exactly what I'm looking for. thanks very much.

Now I need to put this code in a parts list I use at work. Is it possible for you to go through that VBA code step by step or is it something difficult? Would it be a case of copying an pasting in that code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 3 And Target.Row > 1 Then
If Target <> "" And IsNumeric(Target) Then
Target.Offset(0, 1) = Date
Else
Target.Offset(0, 1) = ""
End If
End If
End Sub

Could you recommend a basic VBA resource online so I could start learning and eventually be able to do stuff like this myself.