Turning a cell red

[Sharong]

Hi all, I'm new to forum and hope you can help. I would like to turn a cell red in a query - is this possible or can this only be done in a form or report. I have created a table with medical information and want the cell to turn red when blood pressure entry is greater than 140. Not sure what and where formula should be entered. Any help would be appreciated.


Thanks Sharon : )

[Robeen]

Hi Sharon,
I don't believe it is possible to do conditional colors in a query or table.
I know you can do it on a Form and I have used conditional formatting in reports to turn certain fields red if they exceed an acceptable limit.

[Sharong]

Thank you very much for your reply. I've done it! Had to run a report and the format from there. Sharon

[Robeen]

I'm glad I could help.