Geek Answers Handbook

Excel 2010 - Conditional formatting, color adjacent cells in the same row

Is it possible in Excel 2010 to establish a conditional formatting rule to highlight all non-empty cells in a row when a cell in a particular column has a specific value?

I have a report in which each line identifies a day. I would like to color the gray lines regarding Saturday and Sunday. The day is stored in column C.

I know how to select cells in column C, but how can I easily expand the format of cell C to neighboring non-empty cells on the same row?

+4
source share
2 answers

This is easy to do without a macro and without using a function. INDIRECT

, , 2, "" C , :

, . A2: J100

, ,

=AND($C2="Saturday",A2<>"")

, col C - "", . C2 $, C A2 $

, OR, i.e.

=AND(OR($C2="Saturday",$C2="Sunday"),A2<>"")

.... C

=AND(WEEKDAY($C2,2)>5,$C2<>"",A2<>"")

. CF

+5

, "" .

  • " , , "
  • = WEEKDAY (INDIRECT ( "c" & ROW())) = 1 #
  • ( , ..).
  • OK, .
  • " "
  • "This Worksheet", .
  • " " = $A $1: $J $35 (, , /, )
  • , , , = WEEKDAY (INDIRECT ( "c" & ROW())) = 7 #

. C , 7, , . , ?

+1

More articles:


All Articles