Question Conditional Formatting Data Sheet Row

[Jamz]

Hi Guys,

Is it possible to conditional format a row, or even use VBA or something to match a condition and conditional format a certain cell.

For example:
Product Name Stock
19 Inch Monitor 66
24 Inch Monitor 59
Microsoft Front Page 100

The above shows a list of what is in stock, but for something like Microsoft Front Page, I dont want this visable, so would like to change the font to white (although we have stock of it in, its not a physical item - so I dont need to show quantity, but have just the name output)

Now I can conditional format the cell that features "Microsoft Front Page" but i need the cell that states "100" to be formatted

Something like:

IF ME![ProductName] = "Microsoft Front Page" THEN
ME![CountOfProductID] = Font Colour White
End If

Is this anyway possible?

 

[pbaldy]

Have you looked at Conditional Formatting? It would be simplest. Code really doesn't work in forms in data sheet or continuous views.

 

[Jamz]

Yes i have looked at conditional formatting, but it does not allow you to format one cell from another (as i described above) - Doesnt even allow you to condition a row or column

 

[pbaldy]

It will certainly let you format based on other fields. You select "Expression Is" instead of "Field Value Is". You can do a row in continuous forms view by formatting a large textbox that sits behind all the others. In datasheet view you'll probably need to apply the format to each, but you can highlight them all and do them all at once.

 

[Jamz]

But in datasheet view when you add another text box, it just adds the text box into another column, and not behind another column

 

[pbaldy]

Yes, that's why I said you'd need to apply the format to each text box.