conditional format - gray out if inapplicable

lohj · Jul 13, 2011

Col AF is the Heat Index, only applicable when Col D Temp F Hi is greater than 80F, and Col F Dew point is greater than 54, and Col AE Relative Humidity is greater than 80. I wanted to apply a conditional format to gray out Col AF numbers that don't meet the conditions, so used formula condition
=OR(-100<D2<80, -100< F2<=54, 0<AE2<=40) with gray font but no cells grayed out. If I remove the lower bounds, =OR(D2<80, F2<=54, AE2<=40) entire column is grayed out even the column header text. Not sure why this happens, anyone has the correct way to do this?

Using Excel 2007

Excel Workbook

A

B

D

F

AE

AF

1

Date

Temp F Hi

Max Dewpt F

RH % at Col D Hi Temp

Heat Idx

2

6/5/2011

Sun

77

50

28

77.5

3

6/6/2011

Mon

72

46

33

76.6

4

6/7/2011

Tue

82

48

22

80.0

5

6/8/2011

Wed

84

48

27

81.7

6

6/9/2011

Thu

91

52

14

86.8

7

6/10/2011

Fri

90

48

17

86.1

8

6/11/2011

Sat

90

45

19

86.2

9

6/12/2011

Sun

88

50

25

85.0

10

6/21/2011

Tue

102

48

6

95.9

11

6/22/2011

Wed

104

48

8

98.0

12

6/23/2011

Thu

99

52

17

95.3

13

6/24/2011

Fri

95

45

15

90.6

14

6/25/2011

Sat

97

46

11

92.1

15

6/26/2011

Sun

97

46

12

92.2

16

6/27/2011

Mon

99

43

9

93.7

17

6/28/2011

Tue

93

43

18

89.0

18

6/29/2011

Wed

81

52

29

79.7

19

6/30/2011

Thu

93

48

28

91.1

20

7/1/2011

Fri

100

54

17

96.4

21

7/2/2011

Sat

108

55

6

100.9

22

7/3/2011

Sun

108

54

11

103.1

23

7/4/2011

Mon

100

64

24

99.2

24

7/5/2011

Tue

99

73

40

107.0

25

7/6/2011

Wed

99

70

36

104.2

26

7/7/2011

Thu

100

70

23

98.7

27

7/8/2011

Fri

100

59

22

98.3

28

7/9/2011

Sat

100

50

18

96.8

29

7/10/2011

Sun

99

50

14

94.5

30

7/11/2011

Mon

95

50

12

90.3

Sheet1

Excel 2007

Cell Formulas
Range	Formula
AF2	=IF(ISBLANK(D2), "", -42.379+(2.04901523D2)+(10.14333127AE2)+(-0.22475541D2AE2)+(-0.00683783D2^2)+(-0.05481717AE2^2)+(0.00122874D2^2AE2)+(0.00085282D2AE2^2)+(-0.00000199D2^2AE2^2))
AF3	=IF(ISBLANK(D3), "", -42.379+(2.04901523D3)+(10.14333127AE3)+(-0.22475541D3AE3)+(-0.00683783D3^2)+(-0.05481717AE3^2)+(0.00122874D3^2AE3)+(0.00085282D3AE3^2)+(-0.00000199D3^2AE3^2))
AF4	=IF(ISBLANK(D4), "", -42.379+(2.04901523D4)+(10.14333127AE4)+(-0.22475541D4AE4)+(-0.00683783D4^2)+(-0.05481717AE4^2)+(0.00122874D4^2AE4)+(0.00085282D4AE4^2)+(-0.00000199D4^2AE4^2))
AF5	=IF(ISBLANK(D5), "", -42.379+(2.04901523D5)+(10.14333127AE5)+(-0.22475541D5AE5)+(-0.00683783D5^2)+(-0.05481717AE5^2)+(0.00122874D5^2AE5)+(0.00085282D5AE5^2)+(-0.00000199D5^2AE5^2))
AF6	=IF(ISBLANK(D6), "", -42.379+(2.04901523D6)+(10.14333127AE6)+(-0.22475541D6AE6)+(-0.00683783D6^2)+(-0.05481717AE6^2)+(0.00122874D6^2AE6)+(0.00085282D6AE6^2)+(-0.00000199D6^2AE6^2))
AF7	=IF(ISBLANK(D7), "", -42.379+(2.04901523D7)+(10.14333127AE7)+(-0.22475541D7AE7)+(-0.00683783D7^2)+(-0.05481717AE7^2)+(0.00122874D7^2AE7)+(0.00085282D7AE7^2)+(-0.00000199D7^2AE7^2))
AF8	=IF(ISBLANK(D8), "", -42.379+(2.04901523D8)+(10.14333127AE8)+(-0.22475541D8AE8)+(-0.00683783D8^2)+(-0.05481717AE8^2)+(0.00122874D8^2AE8)+(0.00085282D8AE8^2)+(-0.00000199D8^2AE8^2))
AF9	=IF(ISBLANK(D9), "", -42.379+(2.04901523D9)+(10.14333127AE9)+(-0.22475541D9AE9)+(-0.00683783D9^2)+(-0.05481717AE9^2)+(0.00122874D9^2AE9)+(0.00085282D9AE9^2)+(-0.00000199D9^2AE9^2))
AF10	=IF(ISBLANK(D10), "", -42.379+(2.04901523D10)+(10.14333127AE10)+(-0.22475541D10AE10)+(-0.00683783D10^2)+(-0.05481717AE10^2)+(0.00122874D10^2AE10)+(0.00085282D10AE10^2)+(-0.00000199D10^2AE10^2))
AF11	=IF(ISBLANK(D11), "", -42.379+(2.04901523D11)+(10.14333127AE11)+(-0.22475541D11AE11)+(-0.00683783D11^2)+(-0.05481717AE11^2)+(0.00122874D11^2AE11)+(0.00085282D11AE11^2)+(-0.00000199D11^2AE11^2))
AF12	=IF(ISBLANK(D12), "", -42.379+(2.04901523D12)+(10.14333127AE12)+(-0.22475541D12AE12)+(-0.00683783D12^2)+(-0.05481717AE12^2)+(0.00122874D12^2AE12)+(0.00085282D12AE12^2)+(-0.00000199D12^2AE12^2))
AF13	=IF(ISBLANK(D13), "", -42.379+(2.04901523D13)+(10.14333127AE13)+(-0.22475541D13AE13)+(-0.00683783D13^2)+(-0.05481717AE13^2)+(0.00122874D13^2AE13)+(0.00085282D13AE13^2)+(-0.00000199D13^2AE13^2))
AF14	=IF(ISBLANK(D14), "", -42.379+(2.04901523D14)+(10.14333127AE14)+(-0.22475541D14AE14)+(-0.00683783D14^2)+(-0.05481717AE14^2)+(0.00122874D14^2AE14)+(0.00085282D14AE14^2)+(-0.00000199D14^2AE14^2))
AF15	=IF(ISBLANK(D15), "", -42.379+(2.04901523D15)+(10.14333127AE15)+(-0.22475541D15AE15)+(-0.00683783D15^2)+(-0.05481717AE15^2)+(0.00122874D15^2AE15)+(0.00085282D15AE15^2)+(-0.00000199D15^2AE15^2))
AF16	=IF(ISBLANK(D16), "", -42.379+(2.04901523D16)+(10.14333127AE16)+(-0.22475541D16AE16)+(-0.00683783D16^2)+(-0.05481717AE16^2)+(0.00122874D16^2AE16)+(0.00085282D16AE16^2)+(-0.00000199D16^2AE16^2))
AF17	=IF(ISBLANK(D17), "", -42.379+(2.04901523D17)+(10.14333127AE17)+(-0.22475541D17AE17)+(-0.00683783D17^2)+(-0.05481717AE17^2)+(0.00122874D17^2AE17)+(0.00085282D17AE17^2)+(-0.00000199D17^2AE17^2))
AF18	=IF(ISBLANK(D18), "", -42.379+(2.04901523D18)+(10.14333127AE18)+(-0.22475541D18AE18)+(-0.00683783D18^2)+(-0.05481717AE18^2)+(0.00122874D18^2AE18)+(0.00085282D18AE18^2)+(-0.00000199D18^2AE18^2))
AF19	=IF(ISBLANK(D19), "", -42.379+(2.04901523D19)+(10.14333127AE19)+(-0.22475541D19AE19)+(-0.00683783D19^2)+(-0.05481717AE19^2)+(0.00122874D19^2AE19)+(0.00085282D19AE19^2)+(-0.00000199D19^2AE19^2))
AF20	=IF(ISBLANK(D20), "", -42.379+(2.04901523D20)+(10.14333127AE20)+(-0.22475541D20AE20)+(-0.00683783D20^2)+(-0.05481717AE20^2)+(0.00122874D20^2AE20)+(0.00085282D20AE20^2)+(-0.00000199D20^2AE20^2))
AF21	=IF(ISBLANK(D21), "", -42.379+(2.04901523D21)+(10.14333127AE21)+(-0.22475541D21AE21)+(-0.00683783D21^2)+(-0.05481717AE21^2)+(0.00122874D21^2AE21)+(0.00085282D21AE21^2)+(-0.00000199D21^2AE21^2))
AF22	=IF(ISBLANK(D22), "", -42.379+(2.04901523D22)+(10.14333127AE22)+(-0.22475541D22AE22)+(-0.00683783D22^2)+(-0.05481717AE22^2)+(0.00122874D22^2AE22)+(0.00085282D22AE22^2)+(-0.00000199D22^2AE22^2))
AF23	=IF(ISBLANK(D23), "", -42.379+(2.04901523D23)+(10.14333127AE23)+(-0.22475541D23AE23)+(-0.00683783D23^2)+(-0.05481717AE23^2)+(0.00122874D23^2AE23)+(0.00085282D23AE23^2)+(-0.00000199D23^2AE23^2))
AF24	=IF(ISBLANK(D24), "", -42.379+(2.04901523D24)+(10.14333127AE24)+(-0.22475541D24AE24)+(-0.00683783D24^2)+(-0.05481717AE24^2)+(0.00122874D24^2AE24)+(0.00085282D24AE24^2)+(-0.00000199D24^2AE24^2))
AF25	=IF(ISBLANK(D25), "", -42.379+(2.04901523D25)+(10.14333127AE25)+(-0.22475541D25AE25)+(-0.00683783D25^2)+(-0.05481717AE25^2)+(0.00122874D25^2AE25)+(0.00085282D25AE25^2)+(-0.00000199D25^2AE25^2))
AF26	=IF(ISBLANK(D26), "", -42.379+(2.04901523D26)+(10.14333127AE26)+(-0.22475541D26AE26)+(-0.00683783D26^2)+(-0.05481717AE26^2)+(0.00122874D26^2AE26)+(0.00085282D26AE26^2)+(-0.00000199D26^2AE26^2))
AF27	=IF(ISBLANK(D27), "", -42.379+(2.04901523D27)+(10.14333127AE27)+(-0.22475541D27AE27)+(-0.00683783D27^2)+(-0.05481717AE27^2)+(0.00122874D27^2AE27)+(0.00085282D27AE27^2)+(-0.00000199D27^2AE27^2))
AF28	=IF(ISBLANK(D28), "", -42.379+(2.04901523D28)+(10.14333127AE28)+(-0.22475541D28AE28)+(-0.00683783D28^2)+(-0.05481717AE28^2)+(0.00122874D28^2AE28)+(0.00085282D28AE28^2)+(-0.00000199D28^2AE28^2))
AF29	=IF(ISBLANK(D29), "", -42.379+(2.04901523D29)+(10.14333127AE29)+(-0.22475541D29AE29)+(-0.00683783D29^2)+(-0.05481717AE29^2)+(0.00122874D29^2AE29)+(0.00085282D29AE29^2)+(-0.00000199D29^2AE29^2))
AF30	=IF(ISBLANK(D30), "", -42.379+(2.04901523D30)+(10.14333127AE30)+(-0.22475541D30AE30)+(-0.00683783D30^2)+(-0.05481717AE30^2)+(0.00122874D30^2AE30)+(0.00085282D30AE30^2)+(-0.00000199D30^2AE30^2))

Joe4 · Jul 14, 2011

If I understand you correctly, I think this is the formula you want (starting in row 2):

Code:

=OR($D2<80,$F2<54,$AE2<80)

lohj · Jul 14, 2011

Joe4 - thanks for your help, the conditional formatting formula now reads
=OR($D2<80, $F2<54, $AE2<40). However, the values that are 'rejected' by the OR statement don't meet the conditions (7/4/11, 7/14/11) and the values that should be rejected by not meeting the conditions are grayed (7/5/11).

Excel Workbook

A

B

C

D

E

F

AE

AF

174

6/22/2011

Wed

590

104

66

48

8

98.0

175

6/23/2011

Thu

590

99

72

52

17

95.3

176

6/24/2011

Fri

586

95

66

45

15

90.6

177

6/25/2011

Sat

584

97

64

46

11

92.1

178

6/26/2011

Sun

584

97

63

46

12

92.2

179

6/27/2011

Mon

585

99

59

43

9

93.7

180

6/28/2011

Tue

581

93

61

43

18

89.0

181

6/29/2011

Wed

575

81

61

52

29

79.7

182

6/30/2011

Thu

587

93

50

48

28

91.1

183

7/1/2011

Fri

590

100

55

54

17

96.4

184

7/2/2011

Sat

589

108

61

55

6

100.9

185

7/3/2011

Sun

589

108

72

54

11

103.1

186

7/4/2011

Mon

589

100

73

64

24

99.2

187

7/5/2011

Tue

589

99

70

73

40

107.0

188

7/6/2011

Wed

589

99

70

36

104.2

189

7/7/2011

Thu

589

100

72

70

23

98.7

190

7/8/2011

Fri

588

100

73

59

22

98.3

191

7/9/2011

Sat

585

100

72

50

18

96.8

192

7/10/2011

Sun

584

99

68

50

93.5

193

7/11/2011

Mon

584

95

66

50

12

90.3

194

7/12/2011

Tue

582

91

63

52

15

86.9

195

7/13/2011

Wed

581

88

63

54

23

84.8

196

7/14/2011

Thu

85

61

50

10

81.9

197

7/15/2011

Fri

100

195.3

EDW VBG 2011

Excel 2007

Cell Formulas
Range	Formula
C174	=K174/10
C175	=K175/10
C176	=K176/10
C177	=K177/10
C178	=K178/10
C179	=K179/10
C180	=K180/10
C181	=IF(ISBLANK(K181), "", K181/10)
C182	=IF(ISBLANK(K182), "", K182/10)
C183	=IF(ISBLANK(K183), "", K183/10)
C184	=IF(ISBLANK(K184), "", K184/10)
C185	=IF(ISBLANK(K185), "", K185/10)
C186	=IF(ISBLANK(K186), "", K186/10)
C187	=IF(ISBLANK(K187), "", K187/10)
C188	=IF(ISBLANK(K188), "", K188/10)
C189	=IF(ISBLANK(K189), "", K189/10)
C190	=IF(ISBLANK(K190), "", K190/10)
C191	=IF(ISBLANK(K191), "", K191/10)
C192	=IF(ISBLANK(K192), "", K192/10)
C193	=IF(ISBLANK(K193), "", K193/10)
C194	=IF(ISBLANK(K194), "", K194/10)
C195	=IF(ISBLANK(K195), "", K195/10)
C196	=IF(ISBLANK(K196), "", K196/10)
C197	=IF(ISBLANK(K197), "", K197/10)
AF174	=IF(ISBLANK(D174), "", -42.379+(2.04901523D174)+(10.14333127AE174)+(-0.22475541D174AE174)+(-0.00683783D174^2)+(-0.05481717AE174^2)+(0.00122874D174^2AE174)+(0.00085282D174AE174^2)+(-0.00000199D174^2AE174^2))
AF175	=IF(ISBLANK(D175), "", -42.379+(2.04901523D175)+(10.14333127AE175)+(-0.22475541D175AE175)+(-0.00683783D175^2)+(-0.05481717AE175^2)+(0.00122874D175^2AE175)+(0.00085282D175AE175^2)+(-0.00000199D175^2AE175^2))
AF176	=IF(ISBLANK(D176), "", -42.379+(2.04901523D176)+(10.14333127AE176)+(-0.22475541D176AE176)+(-0.00683783D176^2)+(-0.05481717AE176^2)+(0.00122874D176^2AE176)+(0.00085282D176AE176^2)+(-0.00000199D176^2AE176^2))
AF177	=IF(ISBLANK(D177), "", -42.379+(2.04901523D177)+(10.14333127AE177)+(-0.22475541D177AE177)+(-0.00683783D177^2)+(-0.05481717AE177^2)+(0.00122874D177^2AE177)+(0.00085282D177AE177^2)+(-0.00000199D177^2AE177^2))
AF178	=IF(ISBLANK(D178), "", -42.379+(2.04901523D178)+(10.14333127AE178)+(-0.22475541D178AE178)+(-0.00683783D178^2)+(-0.05481717AE178^2)+(0.00122874D178^2AE178)+(0.00085282D178AE178^2)+(-0.00000199D178^2AE178^2))
AF179	=IF(ISBLANK(D179), "", -42.379+(2.04901523D179)+(10.14333127AE179)+(-0.22475541D179AE179)+(-0.00683783D179^2)+(-0.05481717AE179^2)+(0.00122874D179^2AE179)+(0.00085282D179AE179^2)+(-0.00000199D179^2AE179^2))
AF180	=IF(ISBLANK(D180), "", -42.379+(2.04901523D180)+(10.14333127AE180)+(-0.22475541D180AE180)+(-0.00683783D180^2)+(-0.05481717AE180^2)+(0.00122874D180^2AE180)+(0.00085282D180AE180^2)+(-0.00000199D180^2AE180^2))
AF181	=IF(ISBLANK(D181), "", -42.379+(2.04901523D181)+(10.14333127AE181)+(-0.22475541D181AE181)+(-0.00683783D181^2)+(-0.05481717AE181^2)+(0.00122874D181^2AE181)+(0.00085282D181AE181^2)+(-0.00000199D181^2AE181^2))
AF182	=IF(ISBLANK(D182), "", -42.379+(2.04901523D182)+(10.14333127AE182)+(-0.22475541D182AE182)+(-0.00683783D182^2)+(-0.05481717AE182^2)+(0.00122874D182^2AE182)+(0.00085282D182AE182^2)+(-0.00000199D182^2AE182^2))
AF183	=IF(ISBLANK(D183), "", -42.379+(2.04901523D183)+(10.14333127AE183)+(-0.22475541D183AE183)+(-0.00683783D183^2)+(-0.05481717AE183^2)+(0.00122874D183^2AE183)+(0.00085282D183AE183^2)+(-0.00000199D183^2AE183^2))
AF184	=IF(ISBLANK(D184), "", -42.379+(2.04901523D184)+(10.14333127AE184)+(-0.22475541D184AE184)+(-0.00683783D184^2)+(-0.05481717AE184^2)+(0.00122874D184^2AE184)+(0.00085282D184AE184^2)+(-0.00000199D184^2AE184^2))
AF185	=IF(ISBLANK(D185), "", -42.379+(2.04901523D185)+(10.14333127AE185)+(-0.22475541D185AE185)+(-0.00683783D185^2)+(-0.05481717AE185^2)+(0.00122874D185^2AE185)+(0.00085282D185AE185^2)+(-0.00000199D185^2AE185^2))
AF186	=IF(ISBLANK(D186), "", -42.379+(2.04901523D186)+(10.14333127AE186)+(-0.22475541D186AE186)+(-0.00683783D186^2)+(-0.05481717AE186^2)+(0.00122874D186^2AE186)+(0.00085282D186AE186^2)+(-0.00000199D186^2AE186^2))
AF187	=IF(ISBLANK(D187), "", -42.379+(2.04901523D187)+(10.14333127AE187)+(-0.22475541D187AE187)+(-0.00683783D187^2)+(-0.05481717AE187^2)+(0.00122874D187^2AE187)+(0.00085282D187AE187^2)+(-0.00000199D187^2AE187^2))
AF188	=IF(ISBLANK(D188), "", -42.379+(2.04901523D188)+(10.14333127AE188)+(-0.22475541D188AE188)+(-0.00683783D188^2)+(-0.05481717AE188^2)+(0.00122874D188^2AE188)+(0.00085282D188AE188^2)+(-0.00000199D188^2AE188^2))
AF189	=IF(ISBLANK(D189), "", -42.379+(2.04901523D189)+(10.14333127AE189)+(-0.22475541D189AE189)+(-0.00683783D189^2)+(-0.05481717AE189^2)+(0.00122874D189^2AE189)+(0.00085282D189AE189^2)+(-0.00000199D189^2AE189^2))
AF190	=IF(ISBLANK(D190), "", -42.379+(2.04901523D190)+(10.14333127AE190)+(-0.22475541D190AE190)+(-0.00683783D190^2)+(-0.05481717AE190^2)+(0.00122874D190^2AE190)+(0.00085282D190AE190^2)+(-0.00000199D190^2AE190^2))
AF191	=IF(ISBLANK(D191), "", -42.379+(2.04901523D191)+(10.14333127AE191)+(-0.22475541D191AE191)+(-0.00683783D191^2)+(-0.05481717AE191^2)+(0.00122874D191^2AE191)+(0.00085282D191AE191^2)+(-0.00000199D191^2AE191^2))
AF192	=IF(ISBLANK(D192), "", -42.379+(2.04901523D192)+(10.14333127AE192)+(-0.22475541D192AE192)+(-0.00683783D192^2)+(-0.05481717AE192^2)+(0.00122874D192^2AE192)+(0.00085282D192AE192^2)+(-0.00000199D192^2AE192^2))
AF193	=IF(ISBLANK(D193), "", -42.379+(2.04901523D193)+(10.14333127AE193)+(-0.22475541D193AE193)+(-0.00683783D193^2)+(-0.05481717AE193^2)+(0.00122874D193^2AE193)+(0.00085282D193AE193^2)+(-0.00000199D193^2AE193^2))
AF194	=IF(ISBLANK(D194), "", -42.379+(2.04901523D194)+(10.14333127AE194)+(-0.22475541D194AE194)+(-0.00683783D194^2)+(-0.05481717AE194^2)+(0.00122874D194^2AE194)+(0.00085282D194AE194^2)+(-0.00000199D194^2AE194^2))
AF195	=IF(ISBLANK(D195), "", -42.379+(2.04901523D195)+(10.14333127AE195)+(-0.22475541D195AE195)+(-0.00683783D195^2)+(-0.05481717AE195^2)+(0.00122874D195^2AE195)+(0.00085282D195AE195^2)+(-0.00000199D195^2AE195^2))
AF196	=IF(ISBLANK(D196), "", -42.379+(2.04901523D196)+(10.14333127AE196)+(-0.22475541D196AE196)+(-0.00683783D196^2)+(-0.05481717AE196^2)+(0.00122874D196^2AE196)+(0.00085282D196AE196^2)+(-0.00000199D196^2AE196^2))
AF197	=IF(ISBLANK(D197), "", -42.379+(2.04901523D197)+(10.14333127AE197)+(-0.22475541D197AE197)+(-0.00683783D197^2)+(-0.05481717AE197^2)+(0.00122874D197^2AE197)+(0.00085282D197AE197^2)+(-0.00000199D197^2AE197^2))

Joe4 · Jul 14, 2011

We don't need to see all the worksheet formulas for this example, so please do not post them anywhere (they are just taking up space).

I am confused. Here are your conditions you stated that must ALL be met:

column D>80
column F>54
column AE>40 (I see you amended this error in your last post)

So if any of these are NOT met, you want the value in AF to be greyed out, right? So we just need to check to see if ANY of those three conditions are not met. That is what my formula does.

When I applied the formula to your example, it appears to correctly grey out everything except for the 7/5/2011 date (assuming greying out is the Conditional Format you are selecting).

lohj · Jul 15, 2011

Joe4, still not working in my sheet as it does on yours. IT blocks box.net, so I have to send to myself and post at home. Could you take a look a my sheet and see if there's a setting that needs to be set or something?

File name : lohj1.xls
Owner : name
Description : "having trouble with heat index condtional formatting"
View File <http://www.box.net/shared/jkvi7qx1kyqs877p3841>
To access this shared file, visit this link:
http://www.box.net/shared/jkvi7qx1kyqs877p3841

Joe4 · Jul 18, 2011

Sorry, I was away for a few days. Were you able to figure this out?

My workplace does not allow file downloads, so I would not be able to look at this until tonight. Let me know if you still need help with it.

lohj · Jul 18, 2011

Joe4 - No, still wondering why I get different results than you. Please take a look if you can. Thanks!

Joe4 · Jul 18, 2011

It looks like the row references in your conditional formatting are off a row (row 2 is looking at the values in row 3 instead of row 2). Try clearing your conditional formatting, highlighting cells AF2:AF42 and re-entering your formula, making sure you type in Row 2 row references.

lohj · Jul 18, 2011

Joe4 - your suggestion works! The correct date's data is normal everything else is grayed, thank you very much.

conditional format - gray out if inapplicable

lohj

New Member

Excel Facts

Joe4

MrExcel MVP, Junior Admin

lohj

New Member

Joe4

MrExcel MVP, Junior Admin

lohj

New Member

Joe4

MrExcel MVP, Junior Admin

lohj

New Member

Joe4

MrExcel MVP, Junior Admin

lohj

New Member

Similar threads

Forum statistics

Share this page

conditional format - gray out if inapplicable

New Member

Excel Facts

MrExcel MVP, Junior Admin

New Member

MrExcel MVP, Junior Admin

New Member

MrExcel MVP, Junior Admin

New Member

MrExcel MVP, Junior Admin

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock