[AccessD] Bit OT - Excel Q on Conditional Formatting

On 27 Apr 2006 at 14:36, Darren DICK wrote:

> Hi Dan
> If I select the whole row and set the CondFormatting to say...AirCode
> following...
>    if CellValue = 'Passed' then Grey Font
> 
> But there is nowhere to say if Cell A20 = Passed then Grey font from
> Cell A1 to a19
> 
> That's what I really want to do - apply it to the whole row based on a
> value in a cell Rather that have it apply to a cell based on the value
> in that cell
> 

To highlight all the cells in a row when column H contains the text "Passed":

Select cell A1.
Set your Conditional Format to:  Formula is  = $H1 = "Passed"
Copy the cell.
Select the range that you want the formatting to apply to.
Right Click, Paste Special - Formats