MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 341
- Office Version
- 2013
- Platform
- Windows
Is there a method to cause all rows to have a specific highlight color based upon the text entry in column "A"? The text entry in this column of course would be "Sunday" as indicated in the example.
I should mention that the dates in column "A" are automatic based on the basic formula in this example: =SUM(A11+1). This formula example in my 2019 sheet gives Saturday--05 Jan 2019 because row 11 is Friday--04 Jan 2019. Thus the actual text "Sunday" only appears within the outcome as a result of the formula.
I have a sheet that I record the daily currency exchange rates across several currency types as seen below in the example for Sunday--31 Dec 2017.
What I would like to learn is how to cause every row for a Sunday to become a highlight color without selecting each row. While I realize I would only need to do this about 50 plus times it would sure be good to know how to do this in any event.
Column "A"____________Column "B"_____Column "C"_____Column "D"_____Column "E"_____Column "F"_____Column "G"_____Column "H"_____Column "I"_____Column "J"_____Column "K"
Date_________________EUR to USD_____USD to EUR_____CZK to USD_____USD to CZK____RUB to USD_____USD to RUB_____RUB to CZK____CZK to RUB_____EUR to CZK_____CZK to EUR
Sunday--31 Dec 2017___1.2004600______0.8330100______0.0470000_____21.2754800_____0.0173600_____57.6118300_____0.3692900_____2.7079000_____25.5403600_____0.0391500
I should mention that the dates in column "A" are automatic based on the basic formula in this example: =SUM(A11+1). This formula example in my 2019 sheet gives Saturday--05 Jan 2019 because row 11 is Friday--04 Jan 2019. Thus the actual text "Sunday" only appears within the outcome as a result of the formula.
I have a sheet that I record the daily currency exchange rates across several currency types as seen below in the example for Sunday--31 Dec 2017.
What I would like to learn is how to cause every row for a Sunday to become a highlight color without selecting each row. While I realize I would only need to do this about 50 plus times it would sure be good to know how to do this in any event.
Column "A"____________Column "B"_____Column "C"_____Column "D"_____Column "E"_____Column "F"_____Column "G"_____Column "H"_____Column "I"_____Column "J"_____Column "K"
Date_________________EUR to USD_____USD to EUR_____CZK to USD_____USD to CZK____RUB to USD_____USD to RUB_____RUB to CZK____CZK to RUB_____EUR to CZK_____CZK to EUR
Sunday--31 Dec 2017___1.2004600______0.8330100______0.0470000_____21.2754800_____0.0173600_____57.6118300_____0.3692900_____2.7079000_____25.5403600_____0.0391500