# How to Apply Conditional Formatting in Google Sheets

Viewport: 1920x950 @0.800000011920929x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Apply Conditional Formatting in Google Sheets
   - body: This guide will walk you through the steps to apply conditional formatting in Google Sheets. Conditional formatting allows you to change the appearance of cells in your sheet based on specific conditions you set, making it easier to highlight important information.
   - voiceover: This guide provides detailed instructions on how to use conditional formatting in Google Sheets. Follow these steps to apply visual formatting to specific cells based on their values or text content.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf597000u0cl20f02hda0.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the cells you want
   - source type: IMAGE
   - description: Open the Conditional Formatting Rules
   - target: (833, 195), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - hotspots: 1
     - hotspot_01 (833, 195), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Start by selecting the cells you want to format. Click and drag your mouse over the cells, or hold down the Shift key while using the arrow keys to highlight the desired range.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9mb000w0cl2838o9zz1.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhaewo0000033pp8cpu5df.png
2. step_02 [image] - Click on Format tab
   - source type: IMAGE
   - description: Add a New Rule
   - target: (251.98870398323638, 73.13549256192712), rect: top=33.984375 left=236.11328125 width=62.734375 height=23.984375
   - hotspots: 1
     - hotspot_01 (251.98870398323638, 73.13549256192712), rect: top=33.984375 left=236.11328125 width=62.734375 height=23.984375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Go to the top menu and click on the 'Format' tab. This tab is located between the 'Insert' and 'Data' tabs.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9n1000x0cl20a8ld1um.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhainp0002033p08cmnuhc.png
3. step_03 [image] - Click on Conditional formatting
   - source type: IMAGE
   - description: Select the Range
   - target: (454.41779743633975, 386.8756944459971), rect: top=412.0703125 left=275.3515625 width=150.29296875 height=17.5
   - hotspots: 1
     - hotspot_01 (454.41779743633975, 386.8756944459971), rect: top=412.0703125 left=275.3515625 width=150.29296875 height=17.5
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: From the drop-down menu under the 'Format' tab, find and click on 'Conditional formatting'. This will open a sidebar on the right side of your screen.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9nt000y0cl29vwzezxa.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhajzz0003033pvmybh4tp.png
4. step_04 [image] - Choose the format rules
   - source type: IMAGE
   - description: Choose the Format Cells if Option
   - target: (2073.3248384308376, 351.50567728925165), rect: top=349.16015625 left=2091.23046875 width=248.69140625 height=20
   - hotspots: 1
     - hotspot_01 (2073.3248384308376, 351.50567728925165), rect: top=349.16015625 left=2091.23046875 width=248.69140625 height=20
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: In the conditional formatting sidebar, you will see different format rules. Click on the dropdown to choose a rule that fits your needs, such as 'Text contains', 'Date is', or a custom formula.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9om000z0cl26k4ng0eo.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhalh90004033p9j6zvuag.png
5. step_05 [image] - Type the value you want if you chose text contains rule
   - source type: IMAGE
   - description: Set the Formatting Style
   - target: (2038.6160421915554, 385.4604850317912), rect: top=386.15234375 left=2081.9921875 width=187.2265625 height=35.99609375
   - hotspots: 1
     - hotspot_01 (2038.6160421915554, 385.4604850317912), rect: top=386.15234375 left=2081.9921875 width=187.2265625 height=35.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: If you selected 'Text contains' as your format rule, you need to enter the specific text value in the provided field. For other rules, follow the prompts to enter the necessary criteria.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9pk00100cl2ey2rhhtj.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhan3o0006033p49u70i85.png
6. step_06 [image] - Click the 'Done' button to save your conditional formatting rule.
   - source type: IMAGE
   - description: Save the Rule
   - target: (2325.044843335939, 590.5733821992176), rect: top=561.8359375 left=2280.1171875 width=85.8984375 height=35.99609375
   - hotspots: 1
     - hotspot_01 (2325.044843335939, 590.5733821992176), rect: top=561.8359375 left=2280.1171875 width=85.8984375 height=35.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: After setting up your rule and criteria, click the 'Done' button at the bottom of the sidebar to save your conditional formatting rule. Your selected cells will now be formatted based on the conditions you've set.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf9qf00110cl28szrgmwv.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhaqhb0008033puq1r4l3x.png
8. [Outro] Conditional Formatting Setup Complete
   - body: You have successfully set up conditional formatting for your selected range of cells in Google Sheets. You can now easily identify and highlight key data based on the conditions you've set.
   - voiceover: You can now repeat these steps to add more conditional formatting rules or explore other formatting options in Google Sheets to enhance your data presentation.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhaaiy002bl80ce246nfgd/cm6hhf7ij000v0cl2epdd2fpi.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6hhaaiy002bl80ce246nfgd/tour