tf37
Board Regular
- Joined
- Apr 16, 2004
- Messages
- 169
Been looking through the help for conditional formatting of cells, and just can't seem to find what I'm after...or perhaps what I'm after isn't possible with conditional format
Have a spread sheet that has row1 with receipt numbers, and the row2 below is amounts. This is used between two different locations.
Say location 1 is where I'm at and to let location 2 know that the receipt in row 1 was entered here, I put the letter h in the amount cell (row 2) and highlight row 1 receipt number yellow
Entered in A2 is =A3>0 and conditional format for row a2:l2 is to turn the cell color to yellow.
The cells that they would enter would contain their dollar amounts entered, and should leave the receipt row 1 number with a no fill color.
Is it possible with conditional formatting, or better handled with a "if then" type VBA coding?
Hope that makes sense - thanks
Have a spread sheet that has row1 with receipt numbers, and the row2 below is amounts. This is used between two different locations.
Say location 1 is where I'm at and to let location 2 know that the receipt in row 1 was entered here, I put the letter h in the amount cell (row 2) and highlight row 1 receipt number yellow
Entered in A2 is =A3>0 and conditional format for row a2:l2 is to turn the cell color to yellow.
The cells that they would enter would contain their dollar amounts entered, and should leave the receipt row 1 number with a no fill color.
Is it possible with conditional formatting, or better handled with a "if then" type VBA coding?
Hope that makes sense - thanks