Conditional Formatting

  • Thread starter Thread starter it''''''''sh hardy
  • Start date Start date
I

it''''''''sh hardy

Hey there... I'm trying to conditionally format multiple cells but am having
issues. The format painter does not work properly. Is there a way to do it
for more than one cell at a time?
 
Jacob -

I tried going to that site but it's not working the way I need it to. I have
a sheet that would highlight the highest number in a row for instance F3-F12
but it takes forever to complete one cell at a time
 
F3:F12 is not a row, its a column. Which do you want?

Select a single cell (say A2) and Format - Conditional Format
Formula is:
=A2=MAX(2:2)
for a row, if you meant column
=A2=MAX(A:A)
Select pattern, click 'ok'
Note that lack of asbolute references (the $ symbols).

You can now use the format painter to copy this to any other cell you need.
 
Back
Top